Oracle 11gR2 - Transaction lost in space
Hi all,
I'm currently struck with a transaction problem creating ORA-00054 errors in the application..
If i query V$TRANSACTION i can find a one day old transaction in prepared mode, but there isn't any sessions nor in doubt distributed transactions found
SQL> SELECT XID AS "txn id", XIDUSN AS "undo seg", XIDSLOT AS "slot", XIDSQN AS "seq", STATUS AS "txn status",start_date as "txn start date" FROM V$TRANSACTION;
txn id undo seg slot seq txn status txn start date
---------------- ---------- ---------- ---------- ---------------- -----------------
0A002000999E0200 10 32 171673 PREPARED 18/02/14 07:20:07
SQL> select * from dba_2pc_pending;
aucune ligne selectionnee