Re: Optimal Rollback Segment Size Question

From: Siva <sivar_at_gscrb.sandiegoca.ncr.com>
Date: Fri, 21 Oct 1994 22:09:36 GMT
Message-ID: <sivar.26.00112983_at_gscrb.sandiegoca.ncr.com>

>In article <mlcampb1.2.000AE878_at_ingr.com>, mlcampb1_at_ingr.com (Mike Campbell)
>writes:
>> I know that in Oracle 7 rollback segments can shrink back to a pre-defined
>> optimal size, but I need to know how to make this work.
>>
>> For example, I have a rollback segment that currently as 13 extents allocated
>> using approx. 2.8M of space. If I set the optimal size to 200K, how do I force
>> Oracle to shrink this rollback segment.
>> .. STUFF DELETED ...
>> Any suggestions
>>
>> Mike Campbell
>> mlcampb1_at_ingr.com

You have not mentioned the version of Oracle being used. In 7.0.x, the optimal feature does not work. The bug no. is 149443. I believe it is fixed in 7.1.3.

Cheers

Siva Received on Fri Oct 21 1994 - 23:09:36 CET

This message: [ Message body ]
Next message: Chris eastland: "Re: PCTFREE on indexes"
Previous message: Gavin Maltby, Vector Durban: "Re: What Platform for Oracle7??"
Maybe in reply to: Mike Campbell: "Optimal Rollback Segment Size Question"
In reply to jl34778_at_corp02.d51.lilly.com: "Re: Optimal Rollback Segment Size Question"
Next in thread: Chris eastland: "Re: PCTFREE on indexes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message