Re: sqlldr very very slow

freCho,

[Quoted] Have you solved this yet?

If not you might want to check the values of PCTFREE and PCTUSED on your table. If these added together are close to 100 (say, 95) and your new rows are quite large (say > 10% block size) this might be the cause of your problem. If so, try setting PCTUSED to a much lower value and try the load again. You might be pleasantly surprised.

In any case, a better option with 9i r2 is to use automatic segment space management.

I hope this helps. Received on Mon Feb 07 2005 - 18:29:58 CET