GV$LOCK
select
/*+ ordered use_nl (l), use_nl (s), use_nl (r) +*/ 
s.inst_id,               -- INST_ID NUMBER
l.laddr,                 -- ADDR RAW(4)
l.kaddr,                 -- KADDR RAW(4)
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                   -- BLOCK NUMBER
  (l.lmode, 0, 0, l.block) 
from
v$_lock l,
x$ksuse s,
x$ksqrs r 
where
l.saddr=s.addr and l.raddr=r.addr 

home |  up  |  mailbox