GV$LOCK definition in Oracle 9i / www.oracledba.ru
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