We're having some problem with sqlloader running extremely slow. There are 5 relatively large processes loading at the same time. It takes an average of 3.5 hours to load amount of data that we think should require much less time. Is there any way to monitor background processes during the loads? Are there some parameters I can change in order to help my loads to run faster? Is there anything else I can do?
More detail pleae. like # records, # table, Hardware, SGA
Sun Certified Sys. Admin
I have two questions for you --
1. Do you have any indexes, constraints on the table being loaded?
2. Have you tried the Direct Path Load ?
"Slow" is a relative term...has the performance gone down lately or it has always been like that?
okay, may be a 3rd question...
How many records are you loading ?
One option is to set the table(s) to Nologging before importing using sqlldr, and then change it back to Logging.
Click Here to Expand Forum to Full Width