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

Prints the total UGA for your environment

   <source lang="sql">

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></source>