Here is how to fix Pending Distributed Transactions
Done..!!
SELECT * FROM DBA_2PC_PENDING
COUNT(*)
————–
1
select max(fail_time) from dba_2pc_pending;
MAX(FAIL_
————–
03-DEC-16
select ‘exec dbms_transaction.purge_lost_db_entry(”’||local_tran_id||”’ )’ , ‘commit;’ from
dba_2pc_pending ‘EXECDBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(”’||LOCAL_TRAN_ID||”’)”COMMIT;’
exec dbms_transaction.purge_lost_db_entry(‘15.41.373682’ )
commit;
select count(*) from DBA_2PC_PENDING ;
COUNT(*)
————-
0
Done..!!
Recommended Posts