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, 2008 04:34:09 #5
 sankar21   Member Since: October 2008    Total Comments: 2 

RE: What is the function of checkpoint(CKPT)?
 

Each time logswitch occurs then time ckpt occurs and when shutdowning the database that time occurs, the ckpt gives the signal to DBWn. The DBWn writes from data buffer cache to datafile.  

     

 

Back To Question