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

Home -> Community -> Usenet -> c.d.o.server -> Re: Uncommitted Data

Re: Uncommitted Data

From: VC <boston103_at_hotmail.com>
Date: Wed, 15 Jun 2005 23:06:23 -0400
Message-ID: <INCdnZ98n543cS3fRVn-iQ@comcast.com>

"HansF" <News.Hans_at_telus.net> wrote in message news:pan.2005.06.15.15.27.46.709477_at_telus.net...
> On Wed, 15 Jun 2005 07:59:17 -0700, agarwalp interested us by writing:
>

[...]
> That which is committed is in the tablespace data files.

This is not correct. 'That which is committed' will be in the transaction log (redo log), but not 'in the tablespace data files'.

> It is not
> 'replayed' for a routine instance recovery.

Au contraire, it is.

[...]

> You may also want to review the Oracle Concepts Guide, Chapter 8, which
> has a decent discussion of each of the processes and describes this in a
> lot more detail. Esp. look at the 'lgwr' description.

Indeed.

>
> --
> Hans Forbrich
> Canada-wide Oracle training and consulting
> mailto: Fuzzy.GreyBeard_at_gmail.com
> *** I no longer assist with top-posted newsgroup queries ***
Received on Wed Jun 15 2005 - 22:06:23 CDT

Original text of this message

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