-
Hi,
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?
Thank you.
-
More detail pleae. like # records, # table, Hardware, SGA
Thanks
Chan
OCP7.3/8.0/8i/9i
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 ?
- Rajeev
Rajeev Suri
-
One option is to set the table(s) to Nologging before importing using sqlldr, and then change it back to Logging.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|