Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segment too old
Won't help at all.
That parameter is used to bring public rollback segments online -well, actually it's used to determine how many *ought* to be brought online- at Instance startup.
I doubt you are using public rollback segments. And the parameter has no effect on private ones.
Regards
HJR
"Pinto" <ucanmailme_at_india.com> wrote in message
news:aev0oe$f3b$1_at_news.mch.sbs.de...
> 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 - 06:37:22 CDT