Sunday, January 1, 2012

distributed transactions awaiting recovery


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