GV$SESSION_WAIT
select s.inst_id, -- INST_ID NUMBER s.indx, -- SID NUMBER s.ksussseq, -- SEQ# NUMBER e.kslednam, -- EVENT VARCHAR2(64) e.ksledp1, -- P1TEXT VARCHAR2(64) s.ksussp1, -- P1 NUMBER s.ksussp1r, -- P1RAW RAW(4) e.ksledp2, -- P2TEXT VARCHAR2(64) s.ksussp2, -- P2 NUMBER s.ksussp2r, -- P2RAW RAW(4) e.ksledp3, -- P3TEXT VARCHAR2(64) s.ksussp3, -- P3 NUMBER s.ksussp3r, -- P3RAW RAW(4) decode -- WAIT_TIME NUMBER (s.ksusstim, 0, 0, -1, -1, -2, -2, decode (round (s.ksusstim/10000), 0, -1, round (s.ksusstim/10000))), s.ksusewtm, -- SECONDS_IN_WAIT NUMBER decode -- STATE VARCHAR2(19) (s.ksusstim, 0, 'WAITING', -2, 'WAITED UNKNOWN TIME', -1, 'WAITED SHORT TIME', 'WAITED KNOWN TIME') from x$ksusecst s, x$ksled e where bitand (s.ksspaflg, 1) !=0 and bitand (s.ksuseflg, 1) !=0 and s.ksussseq!=0 and s.ksussopc=e.indx

home |  up  |  mailbox