GV$ENQUEUE_LOCK definition in Oracle 10g / www.oracledba.ru
GV$ENQUEUE_LOCK
select
/*+ ordered use_nl (l), use_nl (s), use_nl (r) +*/
s.inst_id, -- INST_ID NUMBER
l.addr, -- ADDR RAW(4)
l.ksqlkadr, -- KADDR RAW(4)
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$ksqeq l,
x$ksuse s,
x$ksqrs r
where
l.ksqlkses=s.addr and bitand (l.kssobflg, 1) !=0 and (l.ksqlkmod!=0 or l.ksqlkreq!=0) and l.ksqlkres=r.addr