SQL> desc V$session_wait;
Name Null? Type
-------------------------------- -------- ----------------------
SID NUMBER
SEQ# NUMBER
EVENT VARCHAR2(64)
P1TEXT VARCHAR2(64)
P1 NUMBER
P1RAW RAW(4)
P2TEXT VARCHAR2(64)
P2 NUMBER
P2RAW RAW(4)
P3TEXT VARCHAR2(64)
P3 NUMBER
P3RAW RAW(4)
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
WAIT_TIME NUMBER
SECONDS_IN_WAIT NUMBER
STATE VARCHAR2(19)

SQL>

SELECT s.inst_id, s.indx, s.ksussseq, e.kslednam, e.ksledp1, s.ksussp1,
s.ksussp1r, e.ksledp2, s.ksussp2, s.ksussp2r, e.ksledp3, s.ksussp3,
s.ksussp3r, e.ksledclassid, e.ksledclass#, e.ksledclass,
DECODE (s.ksusstim,
0, 0,
-1, -1,
-2, -2,
DECODE (ROUND (s.ksusstim / 10000),
0, -1,
ROUND (s.ksusstim / 10000)
)
),
s.ksusewtm,
DECODE (s.ksusstim,
0, 'WAITING',
-2, 'WAITED UNKNOWN TIME',
-1, 'WAITED SHORT TIME',
DECODE (ROUND (s.ksusstim / 10000),
0, '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;