in-doubt transactions

From: "Girish Shahapurkar" <girish.shahapurkar@xxxxxxxxx>

To: oracle-l@xxxxxxxxxxxxx

Date: Thu, 7 Sep 2006 11:12:27 +0100

Hi,

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.