Oracle Real Memory Usage

[LuchoTB]

I need to show how many memory oracle process is using, with AIX comands.

I use ipcs -bm to show oracle SGA
and ps aux and ps vg to show proceses size.

My serve have about 400 oracle process, but how many menory oracle used really.

How i Can show oracle PGA with AIX commands ?
And how to claculate the sum of all oracle process memory consumption?

Saludos:
Lo mio no es el ingles (se nota)

 

[mrn]

ps vxa | grep ora

Mike

"Whenever I dwell for any length of time on my own shortcomings, they gradually begin to seem mild, harmless, rather engaging little things, not at all like the staring defects in other people's characters."

 

[exsnafu]

svmon -U oracle will give you pretty much all you need to know, svmon -U oracle|head -10 is gonna show you the overall memory footprint for the oracle user in 4k pages. man svmon to understand this better and take note, svmon can be cpu intensive.

you must be root for that, however.