Your database performance has degraded due to frequent checkpointing. What would you do in this
scenario?
A.
make redo log files smaller
B.
increase the size of the checkpoint file
C.
make the changes as per the advice given by MTTR Advisor
D.
make the changes as per the advice given by Checkpoint Advisor
You can specify automatic file extension by specifying an AUTOEXTEND ON clause when you create datafiles using the following SQL statements:
CREATE DATABASE
ALTER DATABASE
CREATE TABLESPACE
ALTER TABLESPACE
The MTTR Advisor (Mean Time To Recover Advisor) is enabled.
When the FAST_START_MTTR_TARGET is set to a non-zero value, combined with STATISTICS_LEVEL being appropriately set, the advisor is started.
Setting of FAST_START_MTTR_TARGET: some of the other parameters are:
FAST_START_IO_TARGET
LOG_CHECKPOINT_INTERVAL
To reduce the checkpoint frequency and optimize runtime performance:
Size your online redo log files according to the amount of redo your system generates.
……
Set the value of FAST_START_MTTR_TARGET (and FAST_START_IO_TARGET) to zero to disable fast-start checkpointing.
No such thing as Checkpoint Advisor