DEVFYI - Developer Resource - FYI

Can one improve the performance of SQL*Loader? (for DBA

ORACLE Interview Questions and Answers (Part 5)

(Continued from previous question...)

890. Can one improve the performance of SQL*Loader? (for DBA

A very simple but easily overlooked hint is not to have any indexes and/or constraints (primary key) on your load tables during the load process. This will significantly slow down load times even with ROWS= set to a high value.
Add the following option in the command line: DIRECT=TRUE. This will effectively bypass most of the RDBMS processing. However, there are cases when you can't use direct load. Refer to chapter 8 on Oracle server Utilities manual.
Turn off database logging by specifying the UNRECOVERABLE option. This option can only be used with direct data loads. Run multiple load jobs concurrently.

(Continued on next question...)

Other Interview Questions