Somtimes in our environment we see that after restart of the database there are some traces of distributed transaction in Logs. so to catch them in database and kill thee i use this procedure
column local_tran_id new_value TRANS_ID
select local_tran_id from dba_2pc_pending;
rollback force '&TRANS_ID';
exec dbms_transaction.purge_lost_db_entry(&TRANS_ID);
No comments:
Post a Comment