CKPT back ground process

Hi Team,

I am trying to understand the oracle back ground process,  Can any one explain me when and how ckpt process is triggered and the tasks it performs on the Database.

Any technical write up or guide should be fine
sam_2012Asked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
It is the Checkpoint process.

As always, I would with the online documentation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/process-architecture.html#GUID-D3174B3E-BCCA-473F-961E-84A36FD5C372
Checkpoint Process (CKPT)

The checkpoint process (CKPT) updates the control file and data file headers with checkpoint information and signals DBW to write blocks to disk. Checkpoint information includes the checkpoint position, SCN, and location in online redo log to begin recovery.

That has a link to:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/oracle-database-instance.html#GUID-A6959126-0ECF-40A2-880D-D74A1BFB5BC4

Overview of Checkpoints

A checkpoint is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle Database operation generally.

Purpose of Checkpoints

Oracle Database uses checkpoints to achieve multiple goals.

Goals include the following:

    Reduce the time required for recovery in case of an instance or media failure

    Ensure that the database regularly writes dirty buffers in the buffer cache to disk

    Ensure that the database writes all committed data to disk during a consistent shutdown



Purpose of Checkpoints

Oracle Database uses checkpoints to achieve multiple goals.

Goals include the following:

    Reduce the time required for recovery in case of an instance or media failure

    Ensure that the database regularly writes dirty buffers in the buffer cache to disk

    Ensure that the database writes all committed data to disk during a consistent shutdown

Thread checkpoints
Tablespace and data file checkpoints
Incremental checkpoints

I'll let you dig through the rest...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.