Re: Which RBS is my Update using ?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Tue, 24 Sep 2002 12:59:42 GMT
Message-ID: <3D9061BE.B41C13FB@peasland.com>

> Daniel,
>
> Why should they all be 1 gig on a read-only database?
>
> Paul

You don't define them *all* to be 1-GB. You only define them to be able to *extend* to 1-GB. Then, make sure you set OPTIMAL so that the one rollback segment that does extend will shrink back to a smaller size. This way, you don't have to set your transaction to use one particular rollback segment. No matter which one it grabs, it has the capability to expand any of the rollback segments to a large enough size.

HTH,
Brian Received on Tue Sep 24 2002 - 07:59:42 CDT