topic Re: current shared memory usage in Operating System - HP-UX

current shared memory usage

Ruediger Noack — Fri, 25 Jan 2002 10:37:51 GMT

Hi all,

I have to recalculate my shared memory parameters for the next oracle instance.
For this i need the current shared memory usage. I think this is the sum of SEGSZ in ipcs -ma.

ipcs -ma | awk '{if ($1=="m") sum+=$10} END {printf "%12d\n",sum}'

Is this correct?

Thanks for your answer.
Ruediger

Re: current shared memory usage

Andreas D. Skjervold — Fri, 25 Jan 2002 10:44:55 GMT

Hi

Thats right.

You can also check against each database instances SGA:
SVRMGR> show sga

Where Total System Global Area should be a similar size.

Have in mind that if you are upgrading Oracle you might need to increase the SGA size. Spesially the Shared_pool_size might need increase (min 50MB for 8i)

Andreas

Re: current shared memory usage

Carlos Fernandez Riera — Fri, 25 Jan 2002 12:22:48 GMT

Maybe you must check kernel parameters (shmmax) too.