Re: rollback segment too old

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 21 Jun 2002 21:37:22 +1000
Message-ID: <aev37f$578$1@lust.ihug.co.nz>

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