Database Administration (MOSC)

MOSC Banner

Oracle 11gR2 - Transaction lost in space

edited Feb 26, 2014 11:49AM in Database Administration (MOSC) 6 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center