I have a scenario where my program is reading data from files using external table / sql loader and loading into a table.
Over a period of time, number of files and file size has grown. To make this load faster,i am using parallel option of external table. But would like know if there are better way by which i can accommodate data upload from multiple file at same time to avoid idle database time.