sqlldr grinding to a halt

I am loading 5000 records into a table at the time using direct path sqlldr in unrecoverable mode on Oracle 8.1.7.

The table has 2 indexes on it which are required for select performance.

It is very fast initially when there are only a few hundred thousand records in the table, but as the table grows the performance of aqlldr is grinding to a halt. The table is expected to hold approx 15m rows.

I cannot load more than 5000 at a time because this is how the data arrives and it must be loaded immediately. I suspect that dropping the indexes would help, but to recreate them after every load of 5000 records would take too long.

Any thoughts? Received on Fri Jan 28 2005 - 05:08:44 CST