DS created database connections

simc · Posted: Thu Jul 16, 2020 11:40 am

Hi All, I'm getting complaints from my DBA about too many database connection being created in my jobs and slowing down the servers. I went through a number of steps that I thought might reduce this number:

- swithced processing from Parralel to Sequential
- reduced to one node in the config file

We've seen no change in the number of database connections.

Any thoughts would be appreciated.

Charles

[/img]

PaulVL · Posted: Sun Jul 19, 2020 3:17 pm

are you doing a read or a write action?

Partitioned Read?

Anything in your SQL statement to pump up the connections?

Nodes in the config file will not matter. You can drop the Oracle Connector stage to sequential mode vs parallel, but, you have to look at those settings.

Is this a Multi Instance job?
Do you have a "before SQL" statement or a before job routine that is also establishing a connection?