How to know how much PGA is getting used at particular point in time..

Hi ,

Any idea how to know , how much PGA is getting used at particular point in time..?

Have a look at the Oracle Doc. There you ll find all you need:

http://download-uk.oracle.com/docs/c...ory.htm#i47865

select sum(s.value) from v$sesstat s, v$statname n
where n.name='session pga memory'
and s.statistic# = n.statistic#;

SELECT * FROM V$PGASTAT;

SELECT PROGRAM, PGA_USED_MEM, PGA_ALLOC_MEM, PGA_FREEABLE_MEM, PGA_MAX_MEM
FROM V$PROCESS;

SELECT * FROM V$PROCESS_MEMORY;


SELECT * FROM V$SQL_WORKAREA_ACTIVE;