Re: How do you shrink rollback segments?

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/03/03
Message-ID: <34FBD977.6A2B28D9@ubs.com>#1/1

Quinton McCombs wrote:
>
> To have the rollback segment automatically shrink use the follwing sql:
>
> alter rollback segemnt <rbs_name>
> storage ( optimial 2.5M );
>
> Replace 2.5M with your actual value.
>

<snip>

But be aware of the mechanisme:
If transaction A requires the rbs to grow over the optimall size, the rbs won't
shrink after the commit(or rollback) of transaction A. The shrink will be done when an other transaction allocates an additional extent in this rbs. Received on Tue Mar 03 1998 - 00:00:00 CST