ORA-00060 dead lock detected,Oracle stage run sequentially

adasgupta123 · Post by **adasgupta123** » Thu Mar 01, 2012 1:17 am

Hi ,

I am having a job where a table is being updated in a Oracle connector stage.
The error the job is throwing :

ORA-00060 dead lock detected while waiting resource

The oracle connector stage is run in sequential mode and the array size is set 1 to avoid the duplicate delete key problem.Even after that the dead lock error is coming.No input row is used in the oracle stage to update the table .A hard coded sql statement is fired from the oracle connector.

Looking for you help.

Thanks and Regards

Avik Dasgupta

adi_2_chaos · Post by **adi_2_chaos** » Thu Mar 01, 2012 3:20 am

This looks more like an Oracle error to me. You may refer the following link
http://www.dba-oracle.com/t_parallel_dm ... tected.htm

You may try running the query separately on Oracle to confirm the same.

Regards
Sriram

SURA · Post by **SURA** » Thu Mar 01, 2012 5:07 pm

1. Is it the new job?

2. Happening regularly / random?

3. Only to this job or some other jobs too which is also doing the same approach to load?

To eliminate the Datastage issue, try it with ODBC and find what is happening!

DS User

kwwilliams · Post by **kwwilliams** » Fri Mar 02, 2012 8:43 am

What is a

duplicate delete key problem

? And what does that have to do with your updates?