oracle 会话内存占用情况查询

查询 oracle 会话的PGA 占用情况，分析任务的执行情况:

-- 查看session PGA内存占用情况
SELECT server,
        s.username,
        oSUSEr,
        NAME,
        VALUE / 1024 / 1024 MB,
        s.SID,
        s.serial#,
        spid
FROM v$session s, v$sesstat st, v$statname sn, v$process p
WHERE st.SID = s.SID
AND st.statistic# = sn.statistic#
AND sn.NAME LIKE 'session pga memory'
AND p.addr = s.paddr
ORDER BY VALUE DESC

对应的如果是查询sga内存的话，sn.NAME LIKE ‘session pga memory’ 改为 sn.NAME LIKE ‘session sga memory’ 即可