Re: sqlldr very very slow

Mentre cercavo di capire la differenza tra una select e un drop database, KeefoBeefo ha scritto:

> freCho,
>
> 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.

Hi KeefoBeefo,
thank's for your post.
I resolved using conventional path committing every 200 records. Why this has been the right way sincerely I don't know!

regards Received on Tue Feb 08 2005 - 15:16:58 CET