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