select
  s.inst_id,                               -- INST_ID NUMBER
  s.kslwtsid,                              -- SID NUMBER
  s.kslwtseq,                              -- SEQ# NUMBER
  e.kslednam,                              -- EVENT VARCHAR2(64)
  e.ksledp1,                               -- P1TEXT VARCHAR2(64)
  s.kslwtp1,                               -- P1 NUMBER
  s.kslwtp1r,                              -- P1RAW RAW(8)
  e.ksledp2,                               -- P2TEXT VARCHAR2(64)
  s.kslwtp2,                               -- P2 NUMBER
  s.kslwtp2r,                              -- P2RAW RAW(8)
  e.ksledp3,                               -- P3TEXT VARCHAR2(64)
  s.kslwtp3,                               -- P3 NUMBER
  s.kslwtp3r,                              -- P3RAW RAW(8)
  e.ksledclassid,                          -- WAIT_CLASS_ID NUMBER
  e.ksledclass#,                           -- WAIT_CLASS# NUMBER
  e.ksledclass,                            -- WAIT_CLASS VARCHAR2(64)
  decode(                                  -- WAIT_TIME NUMBER
    s.kslwtinwait, 0,decode(bitand(s.kslwtflags,256), 0,-2, decode(round(s.kslwtstime/10000), 0,-1, round(s.kslwtstime/10000))), 0),
  decode(                                  -- SECONDS_IN_WAIT NUMBER
    s.kslwtinwait,0,round((s.kslwtstime+s.kslwtltime)/1000000), round(s.kslwtstime/1000000)),
  decode(                                  -- STATE VARCHAR2(19)
    s.kslwtinwait,1,'WAITING', decode(bitand(s.kslwtflags,256),0,'WAITED UNKNOWN TIME', decode(round(s.kslwtstime/10000),0,'WAITED SHORT TIME', 'WAITED KNOWN TIME'))),
  s.kslwtstime,                            -- WAIT_TIME_MICRO NUMBER
  decode(                                  -- TIME_REMAINING_MICRO NUMBER
    s.kslwtinwait,0,to_number(null), decode(bitand(s.kslwtflags,64),64,0,s.kslwttrem)),
  s.kslwtltime                             -- TIME_SINCE_LAST_WAIT_MICRO NUMBER
from
  x$kslwt s,
  x$ksled e
where
  s.kslwtevt=e.indx