Re: Sizing Rollbacks segments

Mark,

This is the second time you have made this statement in the group, and it is simply NOT TRUE. Do you have any evidence, or demonstration program that you can quote which makes you think that it might be true.

RBS (or undo) consists only of a series of (reverse-)change vectors, as far as I know there is NEVER any need for Oracle to copy any entire datablock into the RBS.

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

mark.powell_at_eds.com wrote in message <79s6mn$j08$1_at_nnrp1.dejanews.com>...
> The first time you
delete or change a
>row in a block the entire block is copied to rbs. The next change in a
block
>results in vector information being copied. If the indexes on the table
are
>affected by the update/delete then index blocks also are copied to rbs so
the
>amount of space required varies from one statement to the next.
>
Received on Wed Feb 10 1999 - 09:41:03 CST