From Oracle FAQ
Jump to: navigation, search

CKPT (Oracle Checkpoint Process) is an Oracle background process that timestamps all datafiles and control files to indicate that a checkpoint has occurred.

The "DBWR checkpoints" statistic (v$sysstat) indicates the number of checkpoint requests completed.


The ckeckpoint process was optional in Oracle 7 (set CHECKPOINT_PROCESS=TRUE) and could be enabled to speed-up checkpointing on databases with a large number of files. Starting with Oracle 8i, the checkpoint process is automatically started with the other Oracle processes at instance startup.

Check process[edit]

The following Unix/Linux command is used to check if the CKPT process is running:

$ ps -ef | grep ckpt
oracle   31144     1  0 11:10 ?        00:00:00 ora_ckpt_orcl

Also see[edit]

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 #