in-doubt transactions

From: Girish Shahapurkar <girish.shahapurkar_at_gmail.com>
Date: Thu, 7 Sep 2006 11:12:27 +0100
Message-ID: <974e0450609070312v7f8571e8h1f022bdb71a5f985@mail.gmail.com>

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.

Many Thanks,
Girish

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 07 2006 - 05:12:27 CDT