select
  s.inst_id,                               -- INST_ID NUMBER
  l.laddr,                                 -- ADDR RAW(8)
  l.kaddr,                                 -- KADDR RAW(8)
  s.ksusenum,                              -- SID NUMBER
  r.ksqrsidt,                              -- TYPE VARCHAR2(2)
  r.ksqrsid1,                              -- ID1 NUMBER
  r.ksqrsid2,                              -- ID2 NUMBER
  l.lmode,                                 -- LMODE NUMBER
  l.request,                               -- REQUEST NUMBER
  l.ctime,                                 -- CTIME NUMBER
  decode(l.lmode, 0, 0, l.block)           -- BLOCK NUMBER
from
  v$_lock l,
  x$ksuse s,
  x$ksqrs r
where
  l.saddr=s.addr and l.raddr=r.addr