Mem usage?

[Lorenzo Facello]

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.

[RAC_1 · Accepted solution]

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

[Steve Steel]

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

[Claudio Cilloni]

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