We recently migrated from 8.1 to 9.1 version. For oracle database, we changed from entripse stage to connector stage. we are using 4 node config file. when we run the job, jobs are getting hung. queries are strucked on wait status. DBAs are saying multi DML statements are pointing to same segments/block so query is not completing. Later, we changed the oracle connector stage execution mode to sequential. Jobs are running fine.
Do we need to mention any environment variables? or any config setup we need to do? why connector stage is not working in parallel. Any ideas or suggestions? Thanks in advance.
Oracle connector stage not working in parallel executionmode
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 45
- Joined: Sat May 08, 2010 11:07 pm
- Location: banglore
-
- Participant
- Posts: 45
- Joined: Sat May 08, 2010 11:07 pm
- Location: banglore