topic Re: Mem usage? in Operating System - HP-UX

Mem usage?

Lorenzo Facello — Mon, 03 Jan 2005 09:35:37 GMT

Hi everybody,
I have some oracle processes (almost 70).
In the top... these proc use in the field SIZE- 1850MB each one.
I understood that SIZE is Total virtual size of the process in kilobytes...ok ,but
in your opinion... Is this size too big??
It is a real parameter?

in attach top & swapinfo output.
Thanks
L.F.

Re: Mem usage?

RAC_1 — Mon, 03 Jan 2005 09:45:45 GMT

Do not look at top. Look at glance. top is not a good tool to use, when it comes to checking the memory. Do experience the memory problems?? Open up glance and select the oracle process. This sould give lot of details.

Also you can use following command.
UNIX95= ps -uoracle -o "vsz,args,pid"|sort -nk1

Anil

Re: Mem usage?

Steve Steel — Mon, 03 Jan 2005 09:51:28 GMT

Hi

Look at

ftp://eh:spear9@hprc.external.hp.com/memory.htm

There you can get explanation and better tools to see exqactly wht memory you use

Steve STeel

Re: Mem usage?

Claudio Cilloni — Mon, 03 Jan 2005 10:08:07 GMT

I think it is normal. remember that each oracle server process has visibility over the whole SGA, and 1850 MB should be (more or less...) the size of the SGA of your oracle instance.

but that's not the memory owned by the process, the SGA is shared memory. glance can give you the right value.

Ciao
Claudio