Re: RBS: Optimal ?
Date: 1996/05/29
Message-ID: <Pine.SUN.3.91.960529081234.2770A-100000_at_seatimes>#1/1
On Tue, 28 May 1996, Dinesh Fernandopulle wrote:
> Jason Wells wrote:
> > NORHISHAM BIN MAIN wrote:
> > > In my Oracle 6 databases, we have a script to manually drop all
> > > rollback segments and recreate them whenever we start the database. With
> > > this OPTIMAL feature on Oracle7, does this mean we can skip this step?
> >
> > In Oracle7, rollback segments grow when used and shrink when no longer needed. The rollback
> > segment will shrink down to whatever OPTIMAL is set to. You don't need to specify it, but if you
> > don't, Oracle will set it to some ridiculously small value.
>
> It actually behaves quite unusually. For a RBS that has extended beyond its optimal
> size, it takes another transaction which is again greater than its optimal size to make
> it shrink. And it shrinks down to the new transactions requirement, so hopefully it is
> less than the first requirement.
And, at STARTUP time, all online RBSes are shrunk down to optimal. So, yes, you no longer need that manual script to drop and recreate.
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Wed May 29 1996 - 00:00:00 CEST