Re: Oracle is painfully slow when doing massive INSERTs

From: Wolfgang Diestelkamp <wolfgang.nospam.diestelkamp_at_telia.se>
Date: 1998/03/12
Message-ID: <35082FF5.A87@telia.se>#1/1

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