Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> how to find the lock or sql hold by distributed session?
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
![]() |
![]() |