052-66

You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)
A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

  如果重做日志文件的 size 太小,就会频繁切换日志,即会频繁发生检查点,故可以增大重做日志文件的 size。
  而 FAST_START_MTTR_TARGET 如果设置的太小,根据要控制数据库对单个实例执行崩溃恢复所花费的时间量,则必须频繁发生检查点,来确保内存中已修改的数据块能够定期写入到磁盘,故可以使用 MTTR Advisor 来设置推荐的值。

原文地址:https://www.cnblogs.com/Babylon/p/8004316.html