Tuning sql loader process [message #461334] |
Thu, 17 June 2010 07:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 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.
|
|
|