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
Matt
Messages: 43
Registered: September 1999
Member
Hi

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.

Thanks

Report message to a moderator

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

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

Bruce

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 02:36:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.