Oracle DBA, How To, Error, Cause and Action

ORA-02042: too many distributed transactions

ORA-02042: too many distributed transactions




Cause: the distributed transaction table was full because too many distributed transactions were active.




Action: Run fewer transactions. If you are sure you don't have too many concurrent distributed transactions, this indicates an internal error and support should be notified. Instance shutdown/restart would be a work-around.