Re: Why import slow

If I'm not mistaking - import performs a commit after each record if a table contains a long column even if
you specify a large buffer ...
This implies that importing such a table results in producing 50% of redo wastage (commit entry) and a flush
of the logbuffer at each inserted record...

-> import with commit=N

"Mark" <mbwn_at_inwind.it> wrote in message news:djxY9.45018$YG2.1270864_at_twister1.libero.it...
> Anyone can tell me why the importing of tables with long data fields are
> very very slow compared with other tables?
> Is there any way to make import in a efficent way?
> Such as importing non indexed tables or using a big buffer memory
>
> Thanks
>
>
>
Received on Sat Jan 25 2003 - 09:32:11 CST