SQL Loader - Parallel Load with Muiltiple input files

[tamilselvan]

Hi All,

I have an SQL Loader job which loads data into my target table using direct path (Control file has 100 input files).

Now, I am planning to ADD Parallel Load option to that.

I will have 100 input files. How the PARALLEL option work here?

Will it try to load all the files PARALLELY or will load file by file PARALLELY?

Thanks

Group 100 files into 10 files (concatenate 10 files into 1) , run 10 loader processes for 10 files in parallel.

Tamil