Re: How do you shrink rollback segments?

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.

aa wrote:
>
> I know when you shrink the rollback segment after all transactions are
> committed, it will reduce back to the defined optimum size. My question is:
> is this the only way to reduce it back to the optimum? Or is there some
> parameter that I can set so that it will shrink itself automatically after
> some time?
Received on Mon Mar 02 1998 - 00:00:00 CST