SQL>
SQL> SELECT SUBSTR (a.NAME, 9, 10) "Name",ROUND (SUM (b.VALUE) / 1024 / 1024,1)|| ' M' "Total UGA for all sessions"
2 FROM v$statname a, v$sesstat b
3 WHERE a.statistic# = b.statistic# AND a.NAME = 'session uga memory'
4 GROUP BY a.NAME;
Name Total UGA for all sessions
---------- ------------------------------------------
uga memory 3.5 M
1 row selected.
SQL>
SQL> SET FEEDBACK ON
SQL>
SQL> spool off