Prints the total UGA for your environment : V_statname « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. V_statname

Prints the total UGA for your environment

    

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








Related examples in the same category

1.Show when the current user connected to the system (not available on all platforms).
2.Show when the current user was last active.