Oracle System Architecture Question:

What is the function of checkpoint (CKPT)?

Tweet Share WhatsApp

Answer:

The checkpoint (CKPT) process frees up limited memory space and ensures instance recovery. It is a background process that monitors the number of dirty buffers that have not been written to disk. Depending on the LOG_CHECKPOINT_INTERVAL parameter, it also gives the DBWR a wakeup call to write dirty buffer to disk. At a specified time, it updates all the data and control files with the new log file control number. This process is optionally enabled if parameter CHECKPOINT_PROCESS contains a TRUE value

Download System Architecture PDF Read All 36 System Architecture Questions
Previous QuestionNext Question
Tell me what does LGWR do?Explain when Does DBWR write to the database?