Re: rollback segment usage

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 3 Feb 1999 12:36:30 -0000
Message-ID: <918045376.3716.0.nnrp-11.9e984b29@news.demon.co.uk>

Your statement below is incorrect. Are you thinking about redo logging and tablespaces going into backup mode ?

When a data-changing transaction starts a small number of undo records are written to the RBS, so the first row change probably introduces a slightly larger write to RBS than every other change, but blocks are not copied into the RBS.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

mark.powell_at_eds.com wrote in message <797hft$inl$1_at_nnrp1.dejanews.com>...
>Answers intermixed with original post
>
>In article <7978ia$9vc$1_at_nnrp1.dejanews.com>,
> nguffey_at_jdriscoll.com wrote:
>> Several Questions: 1. When Oracle writes a before image to a rollback
>> segment, is it writing only the row being modified, or is it writing the
>> entire datablock?
>
>The first time a user session modifies a block the entire block has to be
>copied to the rbs segment. The next time a block is copied only vector
>information has to be copied to the rbs segment.
>
Received on Wed Feb 03 1999 - 06:36:30 CST