Mega Code Archive
Prints the total UGA for your environment
<![CDATA[
SQL>
SQL> CLEAR BREAKS
breaks cleared
SQL> CLEAR COLUMNS
columns cleared
SQL> CLEAR COMPUTES
computes cleared
SQL>
SQL> TTITLE OFF
SQL>
SQL> SET ECHO ON
SQL> SET FEEDBACK ON
SQL> SET NULL '<Null>'
SQL> SET PAGESIZE 999
SQL> SET PAUSE OFF
SQL> SET TERM ON
SQL> SET TIME OFF
SQL> SET TIMING OFF
SQL> SET VERIFY OFF
SQL>
SQL> SELECT SUBSTR (a.NAME, 9, 10) "Name",
2 ROUND (SUM (b.VALUE) / 1024 / 1024,
3 1)
4 || ' M' "Total UGA for all sessions"
5 FROM v$statname a, v$sesstat b
6 WHERE a.statistic# = b.statistic# AND a.NAME = 'session uga memory'
7 GROUP BY a.NAME;
Name Total UGA for all sessions
---------- ------------------------------------------
uga memory 4.7 M
1 row selected.
SQL>
]]>