Forum Discussion

giselle_rayner's avatar
giselle_rayner
New Contributor
8 years ago

Increasing batch and fetch size in Oracle account

I am noticing some performance issues when processing larger volumes of data (10 million records) using the Oracle Bulk Loader in Snaplogic. I am able to compare the job as it runs in its current f...
cstewart's avatar
cstewart
Former Employee
7 years ago

The fetch size should not affect the load, it is used when reading from the database with the SELECT Snap.
With the batch size, that will only affect when you use the INSERT or UPDATE. If you are using the BULK Snaps, you should not see any such difference, it will be using SQLLDR under the covers.

PSAmmirata's avatar
PSAmmirata
Employee
5 years ago

Does the Oracle Bulk Load snap make use of the ROWS SQL*Loader Command-Line Parameter or if the parameter isn’t used will the default value be used?

Related Content