Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

transaction lock

redologgerDec 16 2011 — edited Dec 17 2011

hi guys,

i was ask to handle a case requested by out apps team as below:

Quite a few transactions roll back on 15th Dec 2011. The error we obtained on the apps server is as follows:

>
EAError< Thu Dec 15 15:36:32:687 SGT 2011 > [-1acehs] : DataProvider - DataProviderBean: SQL Executer threw this exception com.ea.dataprovider.SQLExecuterException: execute update (database)java.sql.SQLException: ORA-02049: timeout: distributed transaction waiting for lock
>

I was thinking how to find out the other statement that ihas already acquired the table or rows for its transaction since this error thrown out is not 'LIVE'.

How you guys normally approach such issue? I am sure is the way the apps team has written their coding.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2012

Added on Dec 16 2011

#general-database-discussions

10 comments

403 views