Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segments
"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?
-- gregReceived on Thu Jan 11 2001 - 08:37:14 CST