Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Multiversion CC in Oracle

Re: Multiversion CC in Oracle

From: Grant Allen <gxallen_at_gmail.com>
Date: Mon, 29 May 2006 22:36:12 +1000
Message-ID: <447AEABC.8020007@gmail.com>


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

Original text of this message

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