DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2001
    I keep reading everywhere: "just load the tables in parallel." What exactly does this mean? Do I just run two or more shell prompts in the OS and run sqlldr or imp on both of them? Is there a fixed limit on the # of sqlldrs that can be run at one time? Or is it just HW and OS dependent?

    And how does Oracle manage the tasks it's supposed to handle? I.e. there are 3 users.
    User #
    1 System is dropping a schema
    2 scott is loading an employee table of 1M records
    3 Jerry is doing an ad hoc query that is doing a 6 way join where two of the tables are 20 Million rows and only 1 table is indexed.

    How will Oracle start to schedule the tasks? FIFO? Least resources used runs most? Most resources used is run most? Equal time slice multi-tasking. Can this be tuned?

  2. #2
    Join Date
    Dec 1999
    Alpharetta, GA, US
    Oracle use - FIFO

    Good Luck.
    Sun Certified Sys. Admin

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.