Oracle System Architecture Question:
What is the function of checkpoint (CKPT)?
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
Previous Question | Next Question |
Tell me what does LGWR do? | Explain when Does DBWR write to the database? |