Deadlock

sankawa · Post by **sankawa** » Mon Oct 29, 2007 4:42 am

Hi,

i am Using doing lookup and loading the data into Target.Target table contain Unique Key constrants,so i used remove Duplicate for that feild but it still showing the Error:ORA-00060: deadlock detected while waiting for resource.
Please tell what are the reasion for this error.

Regards,
Sandeep

chulett · Post by **chulett** » Mon Oct 29, 2007 6:27 am

Have you talked to your DBA? Have you Googled for that error?

http://www.orafaq.com/faq/what_is_a_dea ... ock_errors

Scope · Post by **Scope** » Mon Oct 29, 2007 6:31 am

Check The Target has Any Lock.If it so, Remove the locks and run the job.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 29, 2007 7:38 am

You don't fix deadlocks. You prevent them.

jstrobel · Post by **jstrobel** » Thu May 15, 2008 12:04 pm

I've seen situations where a deadlock occurs when there are multiple rows incoming with the same keys. If ORACLE stage isn't partitioned by the key, then it's possible for an upsert operation to occur on the same record in two different partitions (nodes) and thus using 2 different oracle connections. This contention can cause a deadlock as well.