What is the incremental checkpointing?

  • From: Peter Teoh <htmldeveloper@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 22 Mar 2008 09:26:16 +0800

Just attended a OU course in Performance Tuning.   After hearing the explanation on incremental checkpointing, I still cannot understand the purpose/design of this incremental checkpointing.

What is the key design, vs complete checkpointing, in Oracle database?   WHat is the tradeoff that it sacrificed, in order to achieve what it does?

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

http://www.vldb.org/conf/1998/p665.pdf

Thanks.
-- //www.freelists.org/webpage/oracle-l

Other related posts: