GV$SESSION_WAIT definition in Oracle 9i / www.oracledba.ru
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