Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: URGENT : sql*loader performance problem on partionned table
Hello
Did you check alert.log for any unusual messages? May be it is using lot of rollback / archiving.
You can use unrecoverable option to load. You have not mentioned whether you are using direct load or not.
Check if too many extents are getting allocated at runtime. That is going to slow down the load.
Presorting data on indexed columns is another method to speeden up load. This is likely to minimise the use of temp segment.
HTH GovindanK
> Hi gurus,
> we have two daily loads that one after the other.
> The first fill up a non partitionned table and the second do the same into
> a
> partitionned table.
> First times the second load ran very quickly : 1 min instead of 5 min (non
> partitionnned table).
> But now since few days, the partitionned table filling take more than 1-2
> hours ! yesterday it took 14 hours !!!!
> Any one has any clue ?
> - Tablespaces for partitionned table used brand new separate disks
> - Does it come from indexes ? should I drop them first ?
>
> Thankx in advance!
>
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: cornichepark_at_cwazy.co.uk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Sep 02 2003 - 19:04:26 CDT