Oracle: Verify PGA and SGA
By admin on Aug 30, 2009 in Oracle, side note
For current PGA size of each session, use:
SELECT s.sid, n.name, s.value FROM v$sesstat s, v$statname n
WHERE s.statistic# = n.statistic#
AND n.name = ‘session pga memory’;
For maximum PGA size each session has reached so far, use:
SELECT s.sid, n.name, s.value FROM v$sesstat s, v$statname n
WHERE s.statistic# = n.statistic#
AND n.name = ‘session pga memory max’;
Sorry, comments for this entry are closed at this time.