Databases Reference
In-Depth Information
7.
Verify other parameters involved in the checkpoint:
SHOW PARAMETER LOG_CHECKPOINT
8.
List parameters related to Fast-Start checkpointing:
SHOW PARAMETER FAST_START
9.
Query the
V$INSTANCE_RECOVERY
dynamic performance view to obtain
estimations on recovery time:
SELECT
RECOVERY_ESTIMATED_IOS,
ESTIMATED_MTTR,
TARGET_MTTR,
LOG_FILE_SIZE_REDO_BLKS,
LOG_CHKPT_INTERVAL_REDO_BLKS,
LOG_CHKPT_TIMEOUT_REDO_BLKS
FROM V$INSTANCE_RECOVERY;
How it works...
In step 2, we verify the value for the
LOG_CHECKPOINTS_TO_ALERT
parameter, and in
step 3 we set it to
TRUE
, to record checkpoint information to the alert log. In step 4, we
force a checkpoint to occur by switching log files.
In the following screenshot, you can see the output of the previous operations:
In step 5, we verify the content of the alert log to be sure that the checkpoint information
is being stored in it.
