smallwei
11:10 pm on January 17, 2010 |
Answers: 1
Tags: cpu (15), database (51), loader, loading (6), oracle (136), performance (16), sql (43), sqlldr 
Loading ...Utilizing parallel loading with Oracle SQL Loader to increase performance.
If you have more than 2 CPU cores on your server, you can run parallel SQL Loader scripts to utilize the extra CPU and increase the performance of your data loading. Follow the parameters below to use parallel loading.
How to Use Oracle Database SQL Parallel Query to Enhance Performance.
Performance Issue with Oracle Database in Windows Server when Running SQL QueryResolving Oracle Problem “… Error While Loading Shared Libraries … Libnnz11…How to Calculate, Compute and Display SQL Script Elapsed Run Time in OracleHow to Escape Ampersand (&) in Oracle SQL Developer.
smallwei 11:10 pm on January 17, 2010
You can use Parallel Loads when you use sqlldr with direct path data loads. This option allows multiple SQL*Loader jobs (scripts) to execute simultaneously. Note: You must also use the append option in your sql loader control file. The parameter to utilize parallel load is “parallel=true”
Here is the example:
Note: we use the “&” to background the jobs in *nix. In Windows, you can submit the jobs separately.