oracle死锁问题

[sheng0512]

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

[一生望云]

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

[一生望云]

多写了execute...

[304的的哥]

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');