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