SELECT sid, trunc((VALUE/1024/1024)) || ' MB' "TOTAL MEMORY FOR ALL SESSIONS", value FROM V$SESSTAT, V$STATNAME WHERE NAME = 'session pga memory' AND V$SESSTAT.STATISTIC# = V$STATNAME.STATISTIC# order by 3 desc;