Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segments

Re: Rollback segments

From: Greg Stark <greg-spare-1_at_mit.edu>
Date: Thu, 11 Jan 2001 14:37:14 GMT
Message-ID: <87k882xiea.fsf@stark.yi.org>

"Howard J. Rogers" <howardjr_at_www.com> writes:

> Incidentally, you are asking for trouble having rollback segments with only
> two extents. The chances of them having to acquire more extents is very
> high (assuming you eventually bring them online).
>
> Rollbacks should have around half a dozen extents to minimise the need to
> extend dynamically

I don't understand how you can say that without knowing the size of the extents and activity. Is there any major functional difference between a rollback segment with 6 1M extents and a rollback segment with 2 3M extents?

-- 
greg
Received on Thu Jan 11 2001 - 08:37:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US