sql loader too slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sql loader too slow

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Wink

    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.

  2. #2
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    More detail pleae. like # records, # table, Hardware, SGA

    Thanks
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

  3. #3
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    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

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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
  •  


Click Here to Expand Forum to Full Width