v$pgastat and untunable memory

Hello!

I have
PGA_AGGREGATE_TARGET=20G
in my init.ora and select * from v$pgastat gives me aggregate PGA auto target about 2Gb during peak load hours. Metalink note 223730.1 says that this value gives me tunable part of PGA memory, so i assume that other 18Gb "are known as untunable, i.e. they require a size that can't be negociated (e.g. context information for each session, for each open/active cursor,
PL/SQL or Java memory)"

So my question is: how can I examine what consumes my pga memory in details? Context information, plsql memory, or something else?

Thanks! Received on Tue Jan 10 2006 - 08:02:28 CST