Re: Optimal Rollback Segment Size Question
From: Chris eastland <extel_at_world.std.com>
Date: Thu, 20 Oct 1994 00:06:31 GMT
Message-ID: <Cxy2yv.Gp5_at_world.std.com>
Date: Thu, 20 Oct 1994 00:06:31 GMT
Message-ID: <Cxy2yv.Gp5_at_world.std.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.
I think you'll find a set transaction use rollback on that segment plus a few heftyish before-image creations will do the trick! It seems to need a bit of a kick to get it trundling back to optimal. Don't know the exact algorithm..
chris Received on Thu Oct 20 1994 - 01:06:31 CET