PGA_AGGREGATE _TARGET

[ramasineParticipante]

Veja se agora vai!

SELECT s.SID SID, LPAD (s.username, 12) oracle_username,
LPAD (s.osuser, 9) os_username, s.program session_program,
LPAD (s.machine, 8) session_machine,
(SELECT ss.VALUE FROM v$sesstat ss, v$statname sn
WHERE ss.SID = s.SID
AND sn.statistic# = ss.statistic#
AND sn.NAME = ‘session pga memory’) session_pga_memory,
(SELECT ss.VALUE FROM v$sesstat ss, v$statname sn
WHERE ss.SID = s.SID AND sn.statistic# = ss.statistic#
AND sn.NAME = ‘session pga memory max’) session_pga_memory_max,
(SELECT ss.VALUE
FROM v$sesstat ss, v$statname sn
WHERE ss.SID = s.SID
AND sn.statistic# = ss.statistic#
AND sn.NAME = ‘session uga memory’) session_uga_memory,
(SELECT ss.VALUE FROM v$sesstat ss, v$statname sn
WHERE ss.SID = s.SID AND sn.statistic# = ss.statistic# AND sn.NAME = ‘session uga memory max’) session_uga_memory_max
FROM v$session s
ORDER BY session_pga_memory DESC

Qq coisa fala!

Abs