Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Uncommitted Data
"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