PGA ocupada por sesion

select spid, program, trunc(pga_used_mem/1024/1024) USED, 
trunc(pga_alloc_mem/1024/1024) ALLOC , trunc(pga_max_mem/1024/1024) MAX 
from v$process 
order by pga_alloc_mem desc;