Oracle PL/SQL Tutorial/System Tables Data Dictionary/sesstat

Prints the total UGA for your environment

SQL>
SQL> CLEAR BREAKS
breaks cleared
SQL> CLEAR COLUMNS
columns cleared
SQL> CLEAR COMPUTES
computes cleared
SQL>
SQL> TTITLE OFF
SQL>
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>
SQL>