Prints the total UGA for your environment : sesstat « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. sesstat

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>