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
ORA-00060 dead lock detected,Oracle stage run sequentially
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Fri Oct 20, 2006 1:58 am
-
- Participant
- Posts: 96
- Joined: Fri Apr 17, 2009 5:58 am
- Location: Delhi
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
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
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
What is a
? And what does that have to do with your updates?duplicate delete key problem
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com