Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
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).
Hope this helps
/Wolfgang
remove all letters except 'o' from 'nospam' to reply Received on Thu Mar 12 1998 - 00:00:00 CST