Re: rollback segment too old

if this is the case, then how will increasing the number of rollback segment avoid this error. wouldn't it still find that the transaction in extent 1 has completed and reuse that extent?
is this the way extents are wrapped? i thought it was in a round robin fashion. only after going through all the other segments will it overwrite the 1st extent if the transaction in the 1st extent has been commited?

thanks,
Pinto.

"Christopher Merry" <merryct_at_constructingbits.com> wrote in message news:uh5pq1o9amp351_at_corp.supernews.com...
> To understand the wrapping issue, lets first focus on how Oracle uses
> rollback segments. More than one transaction may use a particular
rollback
> segment. The only thing Oracle will not do is utilize a single rollback
> segment block for more than one transaction. Further more, Oracle tries
to
> re-use allocated extents within a segment rather than allocating a new
one.
> The only rule here is the head of a transaction, as it fills the extent
and
> moves on, cannot move past the tail (in other words, when wrapping).
Received on Fri Jun 21 2002 - 04:15:46 CDT