Oracle Deadlocks
Posted: Fri Aug 08, 2008 11:55 am
Issue:-
Oracle deadlock issue problem while inserting data into ORACLE DB.
sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource
Issue in detail:-
I am using the parallel ORACLE enterprise stage in my load job to load the transformed data.
During load I am facing deadlock held on the table and the job is getting aborted.
I am using user defined Insert(only Insert) statement on ORACLE stage to load the data and the job is running on 2 nodes.
A strange issue is that, I am facing this above deadlock during my 1st run of job, however if I run the job 2nd time not facing this problem.
Let me know if you require any more information.
Any thoughts on this would be highly appreicated.
Name & Version of Software: DataStage Enterprise Edition, 7.5.1.35
OS & Version: Generic_117350-08, SunOS 5.8
Oracle DB: Oracle 10G
Oracle deadlock issue problem while inserting data into ORACLE DB.
sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource
Issue in detail:-
I am using the parallel ORACLE enterprise stage in my load job to load the transformed data.
During load I am facing deadlock held on the table and the job is getting aborted.
I am using user defined Insert(only Insert) statement on ORACLE stage to load the data and the job is running on 2 nodes.
A strange issue is that, I am facing this above deadlock during my 1st run of job, however if I run the job 2nd time not facing this problem.
Let me know if you require any more information.
Any thoughts on this would be highly appreicated.
Name & Version of Software: DataStage Enterprise Edition, 7.5.1.35
OS & Version: Generic_117350-08, SunOS 5.8
Oracle DB: Oracle 10G