Re: What is the incremental checkpointing?

On Fri, Mar 21, 2008 at 8:26 PM, Peter Teoh <htmldeveloper_at_gmail.com> wrote:

> And what is no-force-at-commit policy, as mentioned in this paper
>

I can take a stab at this... "no-force-at-commit policy" just means that when you COMMIT a transaction, the change is made to a cached copy of the data block in memory - but the data block does not need to be written back to disk for the COMMIT to complete. In Oracle when you insert, update or delete data the actual data block does not get immediately written to disk. The rows you have modified are written to the redo log and the transaction is safe because Oracle can reconstruct the data using an old version of the block plus the redo log.

hope that's helpful,
-Jeremy

-- 
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical

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