Hi ,
Any idea 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;