ORA-02049: timeout: distributed transaction waiting for lock
Dear Community,
We are experiencing in our Production environment a recurrent issue that makes us puzzled because, even though we've been searching the KB and internet resources for a solution, we found several suggestions in terms of configuring the database with proper parameter values, but we are still struggling with this strange behavior.
The current scenario is here following depicted:
we have two Oracle 11.2.0.3 databases on the same HP-UX 11v31 box, communicating via a dblink. Normally we don't have any issue with this architecture, even in case of heavy load but sometimes we our users get ORA-02049 error causing the application session to hang and forcing us to kill frozen sessions.
We are experiencing in our Production environment a recurrent issue that makes us puzzled because, even though we've been searching the KB and internet resources for a solution, we found several suggestions in terms of configuring the database with proper parameter values, but we are still struggling with this strange behavior.
The current scenario is here following depicted:
we have two Oracle 11.2.0.3 databases on the same HP-UX 11v31 box, communicating via a dblink. Normally we don't have any issue with this architecture, even in case of heavy load but sometimes we our users get ORA-02049 error causing the application session to hang and forcing us to kill frozen sessions.
0