SQL & PL/SQL

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!

ORA-03135: connection lost contact Error

650993Aug 27 2009 — edited Aug 27 2009

Hi,

My Application access data from Oracle 10g. Applications hangs when update/delete a specific row in a table. After few minutes application terminates with ORA-03135 error. Rest of application works fine which access around 150+ tables.

If i connect to My Client database server. This works fine. After long analysis, we identified that Update/Delete query on a table hangs due to row level locks. This is not handled on our dtabase server. It was handled in Client database server. So it is working.

Please tell me if any one has any idea, what settings could be wrong with Oracle server. How can we avoid hangs in row level locks without changing the application from DB server side.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2009

Added on Aug 27 2009

1 comment

891 views