您的位置:首页 > 博客中心 > 数据库 >

Oracle CheckPoint usage

时间:2022-03-14 03:16

A checkpoint is the writing by the (database writer) process of all modified buffers in the buffer cache to the database . Data file headers are also updated with the latest checkpoint , even if the file had no changed blocks, as well as the control files.

Checkpoints occur AFTER (not during) every switch and also at intervals specified by initialization parameters.

Set parameter LOG_CHECKPOINTS_TO_ALERT=TRUE to observe checkpoint start and end times in the database alert log.

Checkpoints can be forced with the ALTER SYSTEM CHECKPOINT; command.

 

• A number of dirty database buffers covered by the log being checkpointed are written to the data files by DBWn. The number of buffers being written by DBWn is determined by the FAST_START_MTTR_TARGET parameter, if specified.  (Oracle official doc) .

**AskTom***:  a checkpoint is the act of flushing modified, cached database blocks to disk. Normally, when you make a change to a block -- the modifications of that block are made to a memory copy of the block. When you commit -- the block is not written (but the REDO LOG is -- that makes it so we can "replay" your transaction in the event of a failure). Eventually, the system will checkpoint your modified blocks to disk. there is no relationship between "checkpoint" and sid and instance recovery does not imply "checkpoint". a checkpoint reduces the amount of time it takes to perform instance recovery.......

 

 

 

Oracle Checkpoint

    A checkpoint performs the following three operations:
  1. Every dirty block in the is written to the . That is, it synchronizes the datablocks in the with the on disk.
    It‘s the that writes all modified databaseblocks back to the datafiles.
  2. The latest is written (updated) into the .
  3. The latest SCN is also written to the .
The update of the datafile headers and the control files is done by the ( if CKPT is enabled). As of version 8.0, CKPT is enabled by default.

Events that trigger a checkpoint

The following events trigger a checkpoint.
  • has expired
  • has been reached
  • DBA requires so ()
Additionally, if a is , a checkpoint for the tablespace in question is taking place. While redo log switches cause a checkpoint, .

Time and SCN of last checkpoint

The date and time of the last checkpoint can be retrieved through checkpoint_time in The SCN of the last checkpoint can be found in .checkpoint_change#.

Size of redo log

If the is to small, the performance of the checkpoint will not be optimal. This is the case if the contains messages like .

 

热门排行

今日推荐

热门手游