Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to find the lock or sql hold by distributed session?

how to find the lock or sql hold by distributed session?

From: <guanfeng.guo_at_gmail.com>
Date: 11 Jan 2007 01:50:45 -0800
Message-ID: <1168509044.549308.102510@i56g2000hsf.googlegroups.com>


i can find the distributed transaction info in dba_2pc_pending and dba_2pc_neighbours.and can i find the lock holded by the distributed transactions? i can query v$lock joined with v$transaction,v$session to find the current sql and the locks held by the transaction.then how about distributed transaction? Received on Thu Jan 11 2007 - 03:50:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US