This content has been marked as final. Show 2 replies
And a simple search in this forum gave help ORA-02049
ORA-02049: timeout: distributed transaction waiting for lock Cause: exceeded INIT.ORA distributed_lock_timeout seconds waiting for lock. Action: treat as a deadlock
Edited by: Thierry H. on May 8, 2012 10:08 AM -- link added
distributed_lock_timeout is set to 60, whether we need to increase this ?
As you said to treat this dead lock in oracle dead lock will been taken care automatically so we can leave this error as such is there any chance it will resolve automatically.. please advice.