Database Administration (MOSC)

MOSC Banner

Log switch and Incremental checkpoint

edited Jun 11, 2012 3:27AM in Database Administration (MOSC) 12 commentsAnswered
As per my knowledge, the checkpoint is classified as below (correct me if I am wrong somewhere)
Checkpoint types can be divided as INCREMENTAL and COMPLETE.

Also COMPLETE CHECKPOINT can be divided further into
PARTIAL and FULL.

In Incremental Checkpoint,checkpoint information is written to the
controlfile. In the following cases:

1.Every three second.
2.At the time of log switch - Sometimes log switches may trigger a complete checkpoint , if the
next log where the log switch is to take place is Active.

In complete Checkpoint,checkpoint information is written
in controlfile,datafile header and also dirty block is
written by DBWR to the datafiles.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center