|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
A checkpoint performs the following three operations:
Events that trigger a checkpoint
The following events trigger a checkpoint.
While redo log switches cause a checkpoint, checkpoints don't cause a log switch.
Time and SCN of last checkpoint
The date and time of the last checkpoint can be retrieved through checkpoint_time in v$datafile_header
The SCN of the last checkpoint can be found in v$database.checkpoint_change#.
Size of redo log