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 extents

Re: Rollback extents

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 1 Jul 2002 22:58:22 GMT
Message-ID: <Xns923FA089879gnuegischgnueg@130.133.1.4>

You're right, of course. I meant rollback segments are extremely exciting before 6pm. And also, not only rollback segements are exciting before 6pm, there are other things as well.

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 
>>

>
>
>
-- 
Recherchen im schweizerischen Handelsregister: 
http://www.adp-gmbh.ch/SwissCompanies/Search.php3
Received on Mon Jul 01 2002 - 17:58:22 CDT

Original text of this message

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