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.

No comments:

Post a Comment

Thanks for your comment.