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

Home -> Community -> Usenet -> c.d.o.misc -> Re: before image

Re: before image

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 01 Oct 2004 17:05:41 -0700
Message-ID: <1096675621.567040@yasure>


Odba2003 wrote:

> the question of before image vs pre-image has to do with Automatic Undo
> Management. Here is the context:
>
> Oracle stores the before image of the data in special purpose UNDO tablespaces.
> Oracle also stores pre-images of data to enhance availability and read
> integrity for a query running in one session while another session is
> performing a dml transaction.
>
> I guess my question is, are before images the same thing as pre-images?

Go to http://tahiti.oracle.com and search for multiversion read consistency.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Oct 01 2004 - 19:05:41 CDT

Original text of this message

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