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

home |  up  |  mailbox