Laimutis Nedzinskas wrote:
> Regarding the multiversion concurency control of Oracle:
> Can anyone remind me how oracle finds a particular version of
> block(provided it still exists in the rollback segments)?
>
It doesn't. It reconstructs the block image from the info in undo
(rollback) if it has to. Pretty much part of the Oracle motto - never
do work yourself (record a block at a given SCN) that you can force the
next sucker to do (reconstruct a block at a given SCN).
Ciao
Fuzzy
:-)
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 29 2006 - 07:36:12 CDT
