From Oracle FAQ
Jump to: navigation, search

A checkpoint is the writing by the DBWR (database writer) process of all modified buffers in the SGA buffer cache to the database data files. Data file headers are also updated with the latest checkpoint SCN, even if the file had no changed blocks, as well as the control files.

Checkpoints occur AFTER (not during) every redo log switch and also at intervals specified by initialization parameters.

Set parameter LOG_CHECKPOINTS_TO_ALERT=TRUE to observe checkpoint start and end times in the database alert log.

Checkpoints can be forced with the ALTER SYSTEM CHECKPOINT; command.

Also see[edit]

  • CKPT - Oracle's checkpoint background process
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #