cancel
Showing results for 
Search instead for 
Did you mean: 

current shared memory usage

SOLVED
Go to solution
Ruediger Noack
Valued Contributor

current shared memory usage

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
2 REPLIES
Andreas D. Skjervold
Honored Contributor
Solution

Re: current shared memory usage

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Carlos Fernandez Riera
Honored Contributor

Re: current shared memory usage

Maybe you must check kernel parameters (shmmax) too.
unsupported