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