answersLogoWhite

0

A checkpoint performs the following three operations:

  1. Every dirty block in the buffer cache is written to the data files. That is, it synchronizes the datablocks in the buffer cache with the datafiles on disk.

    It's the DBWR that writes all modified databaseblocks back to the datafiles.

  2. The latest SCN is written (updated) into the datafile header.
  3. The latest SCN is also written to the controlfiles.

The update of the datafile headers and the control files is done by the LGWR(CKPT if CKPT is enabled). As of version 8.0, CKPT is enabled by default.

User Avatar

Wiki User

14y ago

What else can I help you with?