select
  s.inst_id,                               -- INST_ID NUMBER
  l.ktcxbxba,                              -- ADDR RAW(8)
  l.ktcxblkp,                              -- KADDR RAW(8)
  s.ksusenum,                              -- SID NUMBER
  r.ksqrsidt,                              -- TYPE VARCHAR2(2)
  r.ksqrsid1,                              -- ID1 NUMBER
  r.ksqrsid2,                              -- ID2 NUMBER
  l.ksqlkmod,                              -- LMODE NUMBER
  l.ksqlkreq,                              -- REQUEST NUMBER
  l.ksqlkctim,                             -- CTIME NUMBER
  l.ksqlklblk                              -- BLOCK NUMBER
from
  x$ktcxb l,
  x$ksuse s,
  x$ksqrs r
where
  l.ksqlkses=s.addr and bitand(l.ksspaflg,1)!=0 and (l.ksqlkmod!=0 or l.ksqlkreq!=0) and l.ksqlkres=r.addr