in-doubt transactions

  • From: "Girish Shahapurkar" <girish.shahapurkar@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 7 Sep 2006 11:12:27 +0100


Is there way to find out tables/rows involved in in-doubt transactions by
linking transaction id from dba_2pc_pending.
Sometimes we are getting error "ORA-01591: lock held by in-doubt distributed
transaction" and we want to find out the table and the actual row which is
being locked by this if possible.

Many Thanks,

Other related posts:

  • » in-doubt transactions