Database Administration (MOSC)

MOSC Banner

oem sessions inactive for long and consuming a lot of pga

edited Jan 28, 2014 6:39AM in Database Administration (MOSC) 3 commentsAnswered
 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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center