We have to load 2200+ files per day having 77,000 records per file.
We 3 more jobs running parallely which loads the same amount of records into a different tables.
This job is running in production for the last 2 years taking 11-12 hours to just load into the staging table.
DBA's fear that if I add parallel option to my script it will degrade the other jobs performance n blow the machine.
I tried my best and proved that if I execute parallely (5 parallel streams), the job will complete within in 4 hours.
They asked to to tune my SQL Loader files. I dont have any option.
Just to test.