Re: Rollback segment doesn't shrink back to optimal

In article <8s73fr$ij2$1_at_nnrp1.deja.com>,   fsiegel_at_my-deja.com wrote:
> In Oracle 8.0.5 has anyone experienced rollback segments that do not
> shrink back to optimal size after a transaction ends?
>
> The rollback segment AND it's associated tablespace both have
> min extents = 20
>
> The rollback segment has pctincrease 0
> The rollback segment TABLESPACE has pctincrease 50
>
> thank for your time!
>

The optimal setting does not cause rollback segments to shrink at the end of the transaction that caused the rbs to extend. The shrink is done by another transaction when Oracle determines it does not need the extents. It was the same in version 7.

If you can not wait use 'alter rollback segment x shrink;'

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.