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.
答案:BC
解析:题目说因为频繁的checkpoint导致数据库性能降低了,怎么解决
A:禁用automatic checkpoint tuning
B:是否是redo太小
C: 通过mttr advisor的建议修改FAST_START_MTTR_TARGET
D:减小redo文件的数量
参考65题
A:我觉地是对的
B:增大redo,可以减少redo的切换,随之减少了ckpt了,这个是正确的
C:调整FAST_START_MTTR_TARGET配置为合理的值,配置完合理的值得目的是启用automatic checkpoint tuning,如果这个选的话那我觉得A也对了,A都直接关闭了
D:减小redo的数量,这个其实没有关系的主要是与redo的切换有关
所以让我选的话,我选AB
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.
答案:BC
解析:题目说因为频繁的checkpoint导致数据库性能降低了,怎么解决
A:禁用automatic checkpoint tuning
B:是否是redo太小
C: 通过mttr advisor的建议修改FAST_START_MTTR_TARGET
D:减小redo文件的数量
参考65题
A:我觉地是对的
B:增大redo,可以减少redo的切换,随之减少了ckpt了,这个是正确的
C:调整FAST_START_MTTR_TARGET配置为合理的值,配置完合理的值得目的是启用automatic checkpoint tuning,如果这个选的话那我觉得A也对了,A都直接关闭了
D:减小redo的数量,这个其实没有关系的主要是与redo的切换有关
所以让我选的话,我选AB