In our ADF application , Some times ( inconsistently) , we get the error ORA-02049 : timeout: distributed transaction waiting for lock .
We observed that even for simple update statement this issue occurs .
We thought that this might be some data base related issue but DBA denied the thought. Anyways , we want to find out the root cause and give a permanent fix .
Any one has any experiences to handle such issues ? We use ADF 11.1.1.1.5 version .