Monthly Archives: April 2013

ORA-01591: lock held by in-doubt distributed transaction

QL> select * from T_SSIS_TEST; select * from T_SSIS_TEST * ERROR at line 1: ORA-01591: lock held by in-doubt distributed transaction 9.25.27026 SQL> set linesize 9999 SQL> select * from dba_2pc_neighbors; LOCAL_TRAN_ID          IN_ DATABASE     DBUSER_OWNER        I DBID        SESS# BRANCH ———————- … Continue reading

Posted in Database Locks | Leave a comment