GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  System Architecture
Go To First  |  Previous Question  |  Next Question 
 System Architecture  |  Question 21 of 33    Print  
What is the function of checkpoint (CKPT)?
The Checkpoint (CKPT) process is responsible for signaling  DBWR  at checkpoints  and updating all the data files and control files of the database.


  
Total Answers and Comments: 7 Last Update: February 06, 2009   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: partho sarathi konar
 

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



Above answer was rated as good by the following members:
rnraomaddula
April 12, 2005 02:04:53   #1  
Himanshu Dabir        

RE: What is the function of checkpoint (CKPT)?
The CKPT is also useful to get the point in time from where to begin the recovery in case of failure.
 
Is this answer useful? Yes | No
October 01, 2006 13:50:45   #2  
partho sarathi konar        

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


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
October 01, 2008 05:57:48   #3  
subhash.terdale Member Since: October 2008   Contribution: 11    

RE: What is the function of checkpoint(CKPT)?
checkpoint is a background process which ensures dbwn process has written data to datafiles and upadates control file and datafile header to establish data consistency
 
Is this answer useful? Yes | No
October 01, 2008 06:01:57   #4  
subhash.terdale Member Since: October 2008   Contribution: 11    

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

Background process are
Pmon - process monitor
Smon - system Monitor
Dbwn - database buffer writer
Lgwr - log write
Ckpt - checkpoint


 
Is this answer useful? Yes | No
October 06, 2008 04:34:09   #5  
sankar21 Member Since: October 2008   Contribution: 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.


 
Is this answer useful? Yes | No
February 02, 2009 08:22:39   #6  
taya_ronak Member Since: November 2008   Contribution: 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.

 
Is this answer useful? Yes | No
February 06, 2009 08:26:42   #7  
gyanudba Member Since: January 2009   Contribution: 9    

RE: What is the function of checkpoint(CKPT)?
Ckpt (checkpoint) is a background process. It synchronize SCN of all the database files like datafiles control files and redo log files.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape