| Optimal File size for SQL* Loader files [message #71465] |
Wed, 06 November 2002 07:29  |
Ramesh Pisupati
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
We get better performance if we split a Big file (Say 100000 records) into smaller ones (Say 1000 each) and run on multiple sessions instead of running one single Big file size (say 100000)on a single session using SQL*Loader.
What is your comment?
Also, I am looking for some guidelines document which will improve performance for SQL*Loader....PL HELP
|
|
|
|
| Re: Optimal File size for SQL* Loader files [message #71467 is a reply to message #71465] |
Wed, 06 November 2002 07:58  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
performance is definately a trade off..
you can use
1. direct loads
2. use unrecoverable option
3. make simple loads
ie..no concatenations, or continueif structures etc.
4. Avoid delimited fields.use positional fields(with
PRESERVE BLANKS).
and
5. Make sure sql*net tracing is not turned ON.
this happens to be the BIGGEST headache, with SQL*loader.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
