Handle same delete command from 2 different sessions!
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