Hi,
We have designed jobs to extract high volume data from some sources. So, we wanted to configure them for >4nodes configuration.
Some of the jobs have 10 oracle stages. If I execute this job on a 4node configuration, then will I have 40 open database connections (4*10)?
Thanks
Deepti
Number of open oracle/db connections in a job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Could anyone elaborate on how the database connections are established in a parallel job having an oracle stage running sequentially?
Does sequential mode of operation mean that data from the DB is handled by the conductor node and this node opens only a single connection to the oracle DB?
We have about 300 listners set up in the db end. But the extract job having 10 oracle stages is multi instanced and runs for 10 different sources. So, if the extract for all the 10 sources is triggered simultaneously then I'll run into problems with 400 (10*4*10) open connections.
Please advice on the approach to be taken to resolve this issue.
Does sequential mode of operation mean that data from the DB is handled by the conductor node and this node opens only a single connection to the oracle DB?
We have about 300 listners set up in the db end. But the extract job having 10 oracle stages is multi instanced and runs for 10 different sources. So, if the extract for all the 10 sources is triggered simultaneously then I'll run into problems with 400 (10*4*10) open connections.
Please advice on the approach to be taken to resolve this issue.