Pga usage by sessions - Oracle Database Script. SET lines 2000 SELECT SID, b.NAME, ROUND(a.VALUE/(1024*1024), 2) MB FROM v$sesstat a, v$statname b WHERE (NAME LIKE '%session uga memory%' OR NAME LIKE '%session pga memory%') AND a.statistic# = b.statistic# order by ROUND(a.VALUE/(1024*1024),2) desc
SET lines 2000 SELECT SID, b.NAME, ROUND(a.VALUE/(1024*1024), 2) MB FROM v$sesstat a, v$statname b WHERE (NAME LIKE '%session uga memory%' OR NAME LIKE '%session pga memory%') AND a.statistic# = b.statistic# order by ROUND(a.VALUE/(1024*1024),2) desc