Can one improve the performance of SQL*Loader?

santosh
Posts: 1311
Joined: Wed Sep 07, 2016 4:43 pm

Can one improve the performance of SQL*Loader?

Postby santosh » Sat Nov 12, 2016 2:56 pm

Can one improve the performance of SQL*Loader?

raoneel2016
Posts: 824
Joined: Wed Oct 05, 2016 2:40 pm

Re: Can one improve the performance of SQL*Loader?

Postby raoneel2016 » Sat Nov 12, 2016 2:57 pm

1. A very simple but easily overlooked hint, do not have any indexes and/or constraints (primary key) on your load tables during the load process. This
will significantly slowdown load times.
2. Add the following option in the command line: DIRECT=TRUE. This will effectively bypass most of the RDBMS processing.
3. Turn off database logging by specifying the NOLOGGING option. This option can only be used with direct data loads.
4. Run multiple load jobs concurrently.


Return to “Oracle”

Who is online

Users browsing this forum: No registered users and 3 guests