Re: rollback segment too old

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 21 Jun 2002 21:56:13 +1000
Message-ID: <aev4ac$67b$1@lust.ihug.co.nz>

"Pinto" <ucanmailme_at_india.com> wrote in message news:aev3ar$h8k$1_at_news.mch.sbs.de...
> > Actually, a 'wrap' occurs every time we move from one extent to another.
> It
> > has nothing particularly to do with the segment catching up with itself.
> >
> > Regards
> > HJR
>
> Then how can we explain the increase in wraps?
>
>

Not having really followed the thread so far, I can't, other than to say it must be because you're generating more rollback.

Your own figures show as much: before the change in size, you had 1109042956 writes (that is, bytes) across all segments (bar the first, which I assume is the SYSTEM segment). After the change, you had 2452999476 -more than double the quantity of rollback (by my maths, 1.06Gb versus 2.339Gb).

Regards
HJR Received on Fri Jun 21 2002 - 06:56:13 CDT