| |
GeekInterview.com > Interview Questions > Oracle > System Architecture
| Print | |
Question: What is the function of checkpoint (CKPT)?
Answer: The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control files of the database. |
| February 02, 2009 08:22:39 |
#6 |
| taya_ronak |
Member Since: November 2008 Total Comments: 8 |
RE: What is the function of checkpoint(CKPT)?
|
checkpoint is backgroud process. it'll occur in some situations like during log switch, or on the basis of log_checkpoint_interval or log_checkpoint_timeout parameter in parameter file.
checkpoint process will synchronize the logfiles, datafiles and update the controlfile information. there are some data in dirty buffer, whos corresponding log entries are already in logfile. ckpt check this status, ask dbwr to write dirty buffer data to datafiles and also updates controlfile with latest SCN.
|
| |
Back To Question | |
