| Tuning sql loader process [message #461334] |
Thu, 17 June 2010 07:59  |
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
|
Senior Member |
|
|
I have loaded 14324590 rows into target tables using sql*loader.
I used below consideration during the load process.
1) direct=true,parllel=true
2) unrecoverable
3) disable all indexes and triggers.
But, sql loader takes 21 minutes to load 14324590 rows in database?
Could you please give suggest for tuning sql loader process?
Note: we cannot change data file because it has given by client.
Thanks,
Michael Holding.Y
|
|
|
|
|
|
| Re: Tuning sql loader process [message #461348 is a reply to message #461334] |
Thu, 17 June 2010 08:28  |
cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Thats 11369 records per second, which is very fast as far as I'm concerned.
How fast do you want it to be?
If you want some suggestions then you need to do the following:
1) give us the table structure
2) a sample of the data from the file
3) the control file
4) A trace of the process so we can see what time is being spent where.
But personally I suspect it's about as fast as it can possibly get.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
