Re: Free space in rollback segments?

From: Strategic Data Systems <sds_at_dataplusnet.com>
Date: 1997/02/17
Message-ID: <5ealbp$i2l$1@news.inc.net>#1/1

In article <330864E6.3FCC_at_bibip1.wgw.bt.co.uk>, batemam_at_bibip1.wgw.bt.co.uk says...
>
>Jeff Boes wrote:
>>
>> Our database (2 GB data, 2 GB indexes) appears to be running out
>> of rollback segment space.
>
>If there are no large jobs eating into your rollback, then I would
>advise the use of an optimal rollback segment size. The end result is
>that after a job has finished using rollback, if it did extend past the
>optimal setting, it will shrink back the next time someone uses that
>rollback segment.
>

It will ONLY shrink when:

The Rollback segment is used

AND 2. It needs to extend beyond the optimal value for the current transaction. Received on Mon Feb 17 1997 - 00:00:00 CST