Кто из пользовательских сессий ест память : Oracle

SELECT
NVL(A.USERNAME,'(oracle)') AS USERNAME, A.OSUSER,
A.MODULE,A.PROGRAM,sum(TRUNC(B.VALUE/1024/1024)) AS MB,a.machine
FROM GV$SESSION A,GV$SESSTAT B,GV$STATNAME C
WHERE  A.SID = B.SID
AND A.INST_ID = B.INST_ID
AND B.STATISTIC# = C.STATISTIC#
AND B.INST_ID = C.INST_ID
AND C.NAME = 'session pga memory'
AND A.PROGRAM IS NOT NULL
group by a.username,A.OSUSER,A.MODULE,A.PROGRAM,A.MACHINE
order by 5

SELECT
NVL(A.USERNAME,'(oracle)') AS USERNAME, 'ALTER SYSTEM KILL SESSION '''||A.SID||','||A.SERIAL#||''';' as KILL ,A.OSUSER,
A.MODULE,A.PROGRAM,sum(TRUNC(B.VALUE/1024/1024)) AS MB,a.machine
FROM GV$SESSION A,GV$SESSTAT B,GV$STATNAME C
WHERE  A.SID = B.SID
AND A.INST_ID = B.INST_ID
AND B.STATISTIC# = C.STATISTIC#
AND B.INST_ID = C.INST_ID
AND C.NAME = 'session pga memory'
AND A.PROGRAM IS NOT NULL
having 6 > 1
group by a.username,A.SID, A.SERIAL# ,A.OSUSER,A.MODULE,A.PROGRAM,A.MACHINE
order by 6 desc

select se.USERNAME,se.SID,se.SERIAL#,p.SPID, 
p.PGA_USED_MEM/1024/1024/1024 PGA_USED_MEM_Gb,
p.PGA_ALLOC_MEM/1024/1024/1024 PGA_ALLOC_MEM_Gb,
p.PGA_MAX_MEM/1024/1024/1024 PGA_MAX_MEM_Gb
from v$process p
inner join v$session se on se.PADDR=p.ADDR
order by p.PGA_USED_MEM desc

select N.name, M.value 
from v$mystat M, v$statname N
where N.name like '%pga%memory%'
and M.statistic# = N.statistic#;