troubleshooting Question

Preventing deadlock.

Avatar of gram77
gram77Flag for India asked on
Oracle Database
11 Comments1 Solution398 ViewsLast Modified:
I have two tasks, both invoke the same proc in package mypkg.

The proc inserts into a table. Thus we have two sessions inserting into same table through a proc in mypkg.

Thus, Task1 and Task2 tasks failed due to deadlock issue,

Logs:
25-MAY-12 04.51.56.680350000 AM "[do_stuff]{}
Stack:
ORA-00060: deadlock detected while waiting for resource
Backtrace:
ORA-06512: at "DEV.mypkg", line 123"


25-MAY-12 04.51.44.221277000 AM "[do_stuff]{}
Stack:
ORA-00060: deadlock detected while waiting for resource
Backtrace:
ORA-06512: at "DEV.mypkg", line 123"


both tasks finished successfully on rerun induvidually.

What can i do to prevent such deadlock issues when two sessions call the same proc in a package.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros