Session PGA Memory

-- which session are using the most pga mem

select sid,name,value
from v$statname n,v$sesstat s
where 2 n.STATISTIC# = s.STATISTIC#
and name like 'session%memory%'
order by 3 asc

-- Size of the PGA Memory

select sum(value)/1024/1024 Mb, sysdate
from v$sesstat s, v$statname n
where n.STATISTIC# = s.STATISTIC#
and name = 'session pga memory'

*************************************************
keywords: pga memory
*************************************************