Re: Update statement flow

From: Skirao <panandrao_at_gmail.com>
Date: 13 Jun 2005 01:30:07 -0700
Message-ID: <1118651407.360056.79640@g44g2000cwa.googlegroups.com>

Hi,

Just like to add that,

Oracle ALWAYS writes the redo records into the redolog file for any change BEFORE it actually makes the changes in the buffer cache and flushes the block to disk. Unless you are using a NOLOGGING clause, redo is written before undo.

Would suggest you download the Concepts Manual from OTN and read it top to bottom.

If a transaction does not commit and your PC/Server crashes then your change(s) are lost forever.

regards
ski Received on Mon Jun 13 2005 - 03:30:07 CDT