GV$TRANSACTION_ENQUEUE

select
s.inst_id,               -- INST_ID NUMBER
l.ktcxbxba,              -- ADDR RAW(4)
l.ktcxblkp,              -- 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$ktcxb l,
x$ksuse s,
x$ksqrs r 
where
l.ksqlkses=s.addr and bitand (l.ksspaflg, 1) !=0 and (l.ksqlkmod!=0 or l.ksqlkreq!=0) and l.ksqlkres=r.addr
home |  up  |  mailbox