You can control the time and temporary storage used during direct path loads.
To minimize time:
Preallocate storage space
Presort the data
Perform infrequent data saves
Minimize use of the redo log
Specify the number of column array rows and the size of the stream buffer
Specify a date cache value
DB_UNRECOVERABLE_SCN_TRACKING=FALSE. Unrecoverable (nologging) direct writes are tracked in the control file by periodically storing the SCN and Time of the last direct write. If these updates to the control file are adversely affecting performance, then setting the
DB_UNRECOVERABLE_SCN_TRACKING parameter to
FALSE may improve performance.
To minimize space:
When sorting data before the load, sort data on the index that requires the most temporary storage space
Avoid index maintenance during the load