Ora-01591: Lock Held By In-doubt Distributed Transaction...
OS: IBM AIX 5.1
Database : Oracle9i R9.2.0
I have Oracle9i R9.2.0 RAC environment.While updating a Table I got this message:
ORA-01591: LOCK HELD BY IN-DOUBT DISTRIBUTED TRANSACTION...
After Reading many Docs on metalink I followed the Doc# 100664.1 and did the Force Commit;
Once Commit Completed I perform the Normal Database Shutdown and STARTUP to empty the DBA_2PC_PENDING and DBA_2PC_NEIGHBORS data
dictionary views. Still both DBA_2PC_PENDING and DBA_2PC_NEIGHBORS data dictionary views are Not empty.
Can someone suggest what are the Pros/Cons to use
DBMS_TRANSACTION.purge_lost_db_entry to clear DBA_2PC_PENDING and DBA_2PC_NEIGHBORS data dictionary views.As its advised to use only as a last resort after every other measure was implemented including restarting the database.