Re: RBS: Optimal ?
From: Geoff Ingram <lsgvi02_at_chsrh1.agw.bt.co.uk>
Date: 1996/05/29
Message-ID: <31ACDB2B.6F73_at_chsrh1.agw.bt.co.uk>#1/1
All my own personal opionions Received on Wed May 29 1996 - 00:00:00 CEST
Date: 1996/05/29
Message-ID: <31ACDB2B.6F73_at_chsrh1.agw.bt.co.uk>#1/1
[snipped]
> 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.
in 7.2 or later you can explicitly attempt to shrink the RBS with
alter rollback segment <rbs> shrink;
regards Geoff Ingram
All my own personal opionions Received on Wed May 29 1996 - 00:00:00 CEST
