One DS job Creating Multiple oracle session
Posted: Fri Dec 09, 2005 5:44 am
Hi,
We are having a job to update the target table.
After updating some records..Its taking infinite time i..e the job is in running status for long time.
And we conclude that some session may be running,and due this TM type lock have been ocured,and this job is waiting for that session to commit.
And we found that three session are running in oracle for the user,we killed that session and again we started the job .But still we are facing the same issue.i.e again 3 session is running in oracle due this dead lock has been occured.
How a job will create 3 sessions in oracle?Please help to resolve this issue.
Thanks,
Siva.G
We are having a job to update the target table.
After updating some records..Its taking infinite time i..e the job is in running status for long time.
And we conclude that some session may be running,and due this TM type lock have been ocured,and this job is waiting for that session to commit.
And we found that three session are running in oracle for the user,we killed that session and again we started the job .But still we are facing the same issue.i.e again 3 session is running in oracle due this dead lock has been occured.
How a job will create 3 sessions in oracle?Please help to resolve this issue.
Thanks,
Siva.G