Skip to Main Content

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!

Handle same delete command from 2 different sessions!

misterimranJun 27 2012 — edited Jun 27 2012
Dear All,

My database is 11gR2. I am in a situation where 2 applications are using the same database. There are times when the same delete command is issued from both applications that hangs the DB. None of the query is successfully executed.

I want to lock the rows so that the first query executes and while second waits and when first completes second query is executed, though it wont delete any records as records are delete from the first query. But there is no hanging situation. Should I lock the table before running the query? or i first select the records using for update?

Kindly help on this.

Regards,
Imran
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2012
Added on Jun 27 2012
6 comments
564 views