GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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.


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

     

 

Back To Question