Specifying commit=Y directs the import to commit after every full buffer.
You can commit less frequently by increasing the size of the buffer (BUFFER
parameter). In my experience there is usually a sweet performance spot for
the transaction size. Try different sizes until you find the fastest that
doesn't blow the RBS.
"Jaret Lafoudravecmonhai" <toto_at_toto.com> wrote in message
news:9som6g$oh2$1_at_reader1.imaginet.fr...
>
> Due to some RBS too small, I use option commit=y to do an import, but it's
> very slow (4-5 time than commit=N) 10 hours with 5Go. Can I speed up
import
> with commit=Y ?
>
> PS : Oracle 8.0.6 on aix 4.0.6
>
>
>
> Ludovic.
>
>
Received on Mon Nov 12 2001 - 08:52:19 CST
