Re: Multiversion CC in Oracle

  • From: Grant Allen <gxallen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 29 May 2006 22:36:12 +1000

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
:-)

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006