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;