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.
  • Interview Candidate
  • 17
  • 18967

Showing Answers 1 - 17 of 17 Answers

Himanshu Dabir

  • Apr 12th, 2005
 

The CKPT is also useful to get the point in time from where to begin the recovery in case of failure.

  Was this answer useful?  Yes

partho sarathi konar

  • Oct 1st, 2006
 

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

subhash.terdale

  • Oct 1st, 2008
 

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

  Was this answer useful?  Yes

sankar21

  • Oct 6th, 2008
 

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.  

  Was this answer useful?  Yes

taya_ronak

  • Feb 2nd, 2009
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions