| October 10, 2006 13:50:45 |
#2 |
| partho sarathi konar |
Member Since: Visitor Total Comments: N/A |
RE: What is the function of checkpoint(CKPT... |
Hi 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 thanks partho |
| |