Log switch and Incremental checkpoint
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.