SQL Loader - Parallel Load with Muiltiple input files - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: SQL Loader - Parallel Load with Muiltiple input files

  1. #11
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    Hi,

    We have to load 2200+ files per day having 77,000 records per file.

    We 3 more jobs running parallely which loads the same amount of records into a different tables.

    This job is running in production for the last 2 years taking 11-12 hours to just load into the staging table.

    DBA's fear that if I add parallel option to my script it will degrade the other jobs performance n blow the machine.

    I tried my best and proved that if I execute parallely (5 parallel streams), the job will complete within in 4 hours.

    They asked to to tune my SQL Loader files. I dont have any option.

    Just to test.

    Thanks guys.
    Cheers!
    OraKid.

  2. #12
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Only adding the parallel option will do nothing except change the way that free space is used. If there is spare i/o and cpu capacity on the machine then adding more jobs (with parallel set) is a valid approach that they ought not to dismiss without testing
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #13
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Quote Originally Posted by balajiyes
    Hi,


    They asked to to tune my SQL Loader files. I dont have any option.


    Thanks guys.
    You need to replace the DBA ASAP.

    Tamil

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