• Regarding running multiple load processes into a partitioned table at the same time..

    I have found that most systems have a optimal degree of parallelism which is influenced by number of CPU cores (as you discovered), amount of RAM and disk/storage contention.

    It's worthwhile running the system with varying degrees of parallelism to find which one works best.