Oracle System Architecture Question:

Download Job Interview Questions and Answers PDF

What is the function of checkpoint (CKPT)?

System Architecture Interview Question
System Architecture Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what does LGWR do?Explain when Does DBWR write to the database?