current shared memory usage

[Ruediger Noack]

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

[Andreas D. Skjervold · Accepted solution]

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

[Carlos Fernandez Riera]

Maybe you must check kernel parameters (shmmax) too.