0
A checkpoint performs the following three operations:
- Every dirty block in the buffer cache is written to the data files. That is, it synchronizes the datablocks in the buffer cache with the datafiles on disk.
It's the DBWR that writes all modified databaseblocks back to the datafiles.
- The latest SCN is written (updated) into the datafile header.
- The latest SCN is also written to the controlfiles.
The update of the datafile headers and the control files is done by the LGWR(CKPT if CKPT is enabled). As of version 8.0, CKPT is enabled by default.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
Is checkpoint one word?
checkpoint
What part of speech is checkpoint?
Checkpoint is a noun.
What is a good sentence for checkpoint?
he reached the checkpoint
What is the checkpoint to find god in hobo 7?
there is no checkpoint
Name a checkpoint of the Berlin Wall?
Checkpoint Charlie
What was the most famous checkpoint on the Berlin Wall?
Checkpoint Charlie
What is the Concepts in Orphan in distributed database?
In a distributed database, the concept of Orphan refers to a record that exists in an isolated state, disconnected from its related data or parent record. This can occur due to network partitioning or failed synchronization processes, leading to inconsistency within the database. Orphaned records pose challenges for data integrity and can result in potential data corruption if not properly handled.
What is necessary for a cell to pass the G2 checkpoint?
G1/S checkpoint
When was Futian Checkpoint Station created?
Futian Checkpoint Station was created in 2007.
When was Checkpoint Charlie Museum created?
Checkpoint Charlie Museum was created in 1962.
When was Woodlands Train Checkpoint created?
Woodlands Train Checkpoint was created in 1998.
When was checkpoint charlie built?
Checkpoint Charlie was build into the Berlin wall, which began construction on August 15, 1961. The checkpoint's real name was Checkpoint C, but it was called Charlie by the Allied forces because of the NATO alphabet.
