ORA-00060 Deadlock

chaks · Post by **chaks** » Thu Jan 14, 2010 11:19 am

hi i am getting this error while i am trying to insert records in to Oracle Enterprise usinfg auto generated insert then update.

Unable to use a record for update due to ORA-00060: deadlock detected while waiting for resource

edison · Post by **edison** » Thu Jan 14, 2010 3:20 pm

remove oracle table and put peek and run.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 14, 2010 3:50 pm

I'm pretty sure that what was meant there was to remove the Oracle stage.

Think about possible causes of deadlock. Might the same key be arriving from more than one partition? Are you trying to insert into the same table as one from which you are selecting?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jan 14, 2010 5:38 pm

Try running in single node.

chulett · Post by **chulett** » Thu Jan 14, 2010 5:55 pm

This topic would be a great conversation starter for your DBA.