Home » RDBMS Server » Server Utilities » Tuning sql loader process (Oracle 11g,linux)
Tuning sql loader process [message #461334] Thu, 17 June 2010 07:59 Go to next message
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 #461345 is a reply to message #461334] Thu, 17 June 2010 08:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check disk performances during the load. I think you are close to overload.

Regards
Michel
Re: Tuning sql loader process [message #461348 is a reply to message #461334] Thu, 17 June 2010 08:28 Go to previous message
cookiemonster
Messages: 13917
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.
Previous Topic: Invalid geometries after import sqlldr
Next Topic: data pump worker parallelism
Goto Forum:
  


Current Time: Fri Mar 29 10:29:03 CDT 2024