Re: Oracle is painfully slow when doing massive INSERTs

Mark Usrey wrote:
>

[ ... ]

> > It seems to me that it all boils down to one thing: Oracle's just plain
> > painfully slow on massive INSERT's....
> >
> > Any ideas, anyone?
> >
>
> You did mention any indices that are kept on you destination table. Large

[...]
>
> If you are keeping indices, try dropping them before doing the insert, and then
> recreating them afterwards.

[Quoted] Another reason could be that the rollback segment just grows forever if you don't do a commit. Try to commit every n rows (n beeing in the range of 100 to 1000 maybe).

[Quoted] Hope this helps
/Wolfgang

remove all letters except 'o' from 'nospam' to reply Received on Thu Mar 12 1998 - 00:00:00 CET