ZogBit

The sql below can be run to show who is using memory and how much memory.

select S.sid, S.USERNAME, PM.category, PM.ALLOCATED,
       ROUND(PM.USED/(1024*1024),0) as USED_MB, PM.MAX_ALLOCATED, SQL_TEXT
 from v$process_memory pm
inner join v$process p
        on p.pid = pm.pid
inner join v$session s
        on s.paddr = p.addr
inner join v$sql sq
        on sq.sql_id = s.sql_id
 order by PM.USED desc nulls last
/