в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:08:05Z

1 версия

Новая страница

== 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>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/System Tables Data Dictionary/sesstat - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия