Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

functionality of CKPT

Pavan DBAMay 26 2008 — edited May 27 2008
Hi experts i had a query regarding actions preformed by CKPT.

Every three seconds, the checkpoint process (CKPT) records information in the control file about the checkpoint position in the online redo log.

The following is posted by one of our expert in some thread.

CKPT process will do the following things:
1)Flushes the redo log buffer to redo log files by means of LGWR.
2)Writes a checkpoint record to the redo log file.
3)Initiates DBWR to write all dirty blocks back to the datafiles, thus synchronizes the database.
4)Updates the headers of the data files with information about the last checkpoint performed.
5)Update the control files about the last checkpoint.

By the above two statements(which are in bold), can we conclude that even redo log file will have checkpoint information and it will be written by CKPT process?

plz explain. thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2008
Added on May 26 2008
21 comments
3,159 views