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!

How to avoid Dead Lock?

BS2012Aug 9 2012 — edited Aug 9 2012

Hi All,
When I am trying to execute my procedure, sometimes it's successful but sometimes it's terminated because of Deadlock. I know this happened due to multiple sessions are waiting for data locked by each other, resulting in all the sessions being blocked. But how can this be avoided? Please suggest something.

Regards,
BS

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2012

Added on Aug 9 2012

15 comments

550 views