Skip to content. | Skip to navigation
How to Query the Process Global Area (PGA) statistics.
SELECT name, SUM(value) FROM v$sesstat a, v$statname b WHERE a.statistic# = b.statistic# AND UPPER(name) like '%PGA%' GROUP BY name