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?