oracle死锁问题

Question

select a.local_tran_id,a.state,a.force_time,a.retry_time,b.in_out,b.database
 from DBA_2PC_PENDING a,DBA_2PC_NEIGHBORS b where a.local_tran_id=b.local_tran_id查出的a.state中有collecting,请问哪位知道这个怎么改成forced commit

Answer 1

执行
begin
   execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('你查询出来的local_tran_id值');
end;

Answer 2

DBA_2PC_PENDING
forced commit：在使用commit force出现
解决方法： execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('1.10.255');SQL> alter session set "_smu_debug_mode" = 4;
SQL>execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('local_tran_id');