precision : Oracle 8.1.7.3 (64 bits) in Solaris 8
-----Message d'origine-----
De : NGUYEN Philippe (Cetelem)
Envoy� : 02 September 2003 18:14
� : '[EMAIL PROTECTED]'
Objet : URGENT : sql*loader performance problem on partionned table
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!
