Re: v$pgastat and untunable memory

Hello!

Thanks for your reply, Jonathan.

We are running 9.2.0.6 64bit on Aix 5.3.

The whole v$pgastat view looks like this:

aggregate PGA target parameter	21474836480
aggregate PGA auto target	3616468992
global memory bound	104857600
total PGA inuse	17545417728
total PGA allocated	20252230656
maximum PGA allocated	22105217024
total freeable PGA memory	2009137152
PGA memory freed back to OS	712509751296
total PGA used for auto workareas	88340480
maximum PGA used for auto workareas	637140992
total PGA used for manual workareas	0
maximum PGA used for manual workareas	1073152
over allocation count	0
bytes processed	14204348607488
extra bytes read/written	850115845120
cache hit percentage	94.35

I know about that columns in v$process, but how can I tell, for example, how much space from that process private memory has been used for holding local contexts?

Bye. Received on Wed Jan 11 2006 - 04:40:14 CST