Re: Do I really need more than 1 rollback segment?

"Stephan Bressler" <stephan.bressler_at_pdb.sbs.de> wrote in message news:<9un848$sj4$1_at_news.mch.sbs.de>...
> Hi Benjamin,
>
> unfortunately you misses to describe what kind off failures / errors you
> get.
> 200-300 inserts per 15 Seconds should not bother rollback segments very much
> for insert don't have a (significant) before-image (unlike update or delete)
> which goes to the rbs.
>
> Please give us more details about the errors you get.
>
> Regards
> Stephan
>

1- Stan, Steve is correct in that the exact Oracle error you are getting is required to provide the most likely answer

2- Have you determined exactly how much data is involved in these inserts including the indexes? Have you made sure that the updating process was not changed?

• Mark D Powell --