--VALUE默认为字节 SELECT round(SUM(VALUE) / 1024 / 1024, 2) "使用UGA(M)" FROM v$mystat, v$statname WHERE NAME = 'session uga memory' AND v$mystat.statistic# = v$statname.statistic#;SELECT round(SUM(VALUE) / 1024 / 1024, 2) "曾经使用最大UGA(M)" FROM v$sesstat, v$statname WHERE NAME = 'session uga memory max' AND v$sesstat.statistic# = v$statname.statistic#;
SELECT round(SUM(VALUE) / 1024 / 1024, 2) "使用UGA(M)"
FROM v$mystat, v$statname
WHERE NAME = 'session uga memory' AND
v$mystat.statistic# = v$statname.statistic#;SELECT round(SUM(VALUE) / 1024 / 1024, 2) "曾经使用最大UGA(M)"
FROM v$sesstat, v$statname
WHERE NAME = 'session uga memory max' AND
v$sesstat.statistic# = v$statname.statistic#;