Re: Rollback extents

Hi Rene,

I'm somewhat concerned that you find rollback segments extremely exciting. This is not a health sign and is a path that leads only to distress and ultimately, disillusionment (wait until you see what Oracle have done to the little buggers in 9i ;)

Can I suggest a break from what you're doing and consider relaxing to David Bowie's new album Heathen, now that is something to be excited about :)

Cheers

Richard
"Rene Nyffenegger" <rene.nyffenegger_at_gmx.ch> wrote in message news:Xns923BCFECF86gnuegischgnueg_at_130.133.1.4...
>
> > And also the original poster seems to imagine that rollback io is done
> > on a per row changed rather than a per block changed basis.
>
> And if it was not the OP that imagined so, at least I did. Well, again
> something where I was wrong in my thinking about how Oracle internally
> handles things.
>
> Does your answer imply that oracle used a full redo block as soon as a
> transaction changes only a byte on a db block, but never uses more than
> one redo block for every block on which a byte is changed.
>
> Could you give me a pointer where I find more about this things. I find
them
> extremly exciting.
>
> Rene
>
>
>
>
>
>
> --
> Recherchen im schweizerischen Handelsregister:
> http://www.adp-gmbh.ch/SwissCompanies/Search.php3
>
Received on Sun Jun 30 2002 - 03:17:17 CDT