The OCI function OCIStmtExecute returned status 1. Error code: 60, Error message: ORA-00060: deadlock detected while waiting for resource.
Please help me out,What are the steps to be taken to resolve that
ERROR While Loading from oracle to oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 58
- Joined: Mon Dec 14, 2015 3:16 pm
- Location: Arizona
Resolve the deadlock. If you're not sure what that means, enlist your Oracle DBA. They may be able to trace the execution of the job from the database side and give you some clues.
Typically it is caused by running your job on multiple nodes with improper partitioning. If you are running on more than one node, switch it to a single node configuration and see if that 'solves' it.
Typically it is caused by running your job on multiple nodes with improper partitioning. If you are running on more than one node, switch it to a single node configuration and see if that 'solves' it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers