Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segment too old
will it help if i increase the transactions_per_rollback_segment value.
currently it is the default value of 5.
Thanks,
Pinto.
"Knut Talman" <knut.talman_at_mytoys.de> wrote in message
news:3D130468.826B5A8A_at_mytoys.de...
> Pinto wrote:
>
> > if you can see, the wraps have more than doubled. and as expected i am
still
> > getting ora-1555
>
> Not only the size of a rollback segment can become a bottleneck also the
number
> of rbs is important. Every transaction has to use the header of the rbs to
enter
> its information. If there are no slots left (in the header) you'll get
> ORA-01555, even if there are a lot of free rollback segment blocks.
>
> Regards,
>
> Knut
Received on Fri Jun 21 2002 - 05:54:44 CDT