oem sessions inactive for long and consuming a lot of pga
SQL> SELECT s.last_call_et,p.pga_alloc_mem,p.spid,p.pid,s.sid,s.serial#,s.status,s.username,s.osuser,s.program FROM v$process p,v$session s WHERE s.paddr ( + ) = p.addr and s.status!='ACTIVE' Order by p.pga_alloc_mem desc;
LAST_CALL_ET PGA alloc OSpid Orapid Sess id Serial# Status oracleuser OS user Program
------------ --------------- -------- ------- ------- ------- -------- ------------ ------------ --------------------
11309 48,138,922 12583402 98 245 28039 INACTIVE AIXBOMS_ADMI Dan Lee Toad.exe
N
3089215 13,470,378 21430340 75 361 193 INACTIVE DBSNMP oracle emagent@amdc-oragrid
-ux03 (TNS V1-V3)
46 13,339,306 27525410 63 823 15 INACTIVE DBSNMP oracle emagent@amdc-oragrid
-ux03 (TNS V1-V3)
0