Home » RDBMS Server » Server Utilities » SQL*Loader - Slow in processing!
SQL*Loader - Slow in processing! [message #367988] Tue, 07 September 1999 18:05 Go to next message
Messages: 43
Registered: September 1999

I am calling SQL*Loader from Forms 3 to upload a file. The files contains 9000 records and takes about 5 minutes to load.

Any suggestions about improving the performance?

I've tried altering the ROWS parameter, and that hasn't helped.

Re: SQL*Loader - Slow in processing! [message #367991 is a reply to message #367988] Thu, 09 September 1999 10:50 Go to previous message
Messages: 21
Registered: November 1998
Junior Member

Try dropping all indexes except any that are enforcing uniqueness. Recreate the indexes after the load is done.

Previous Topic: Ignoring specific fields in data
Next Topic: Scheduling sql*loader in windows95 platform
Goto Forum:

Current Time: Fri Dec 01 13:10:58 CST 2023