本文涵盖了Oracle Optimizer Statistics Advisor的功能，它能推荐改善统计收集过程的改变，并包含在DBMS_STATS包中。此外，解释了RMAN `BACKUP RECOVERY FILES`命令的作用，该命令备份当前快速恢复区中所有未备份的Oracle恢复文件。最后，讨论了Oracle数据库调优方法，强调调优活动应基于服务级别协议，并且SQL调优的重要性。
#完整版可于资源里下载
Which three are true about Optimizer Statistics Advisor? (Choose three.) A. It can be run only manually.
B. It is part of the DBMS_ADVISOR package.
C. It can recommend changes to improve the statistics gathering process.
D. It always analyzes all schemas in the database.
E. It runs automatically every night by default.
F. It is part of the DBMS_STATS package.
Answer: CEF
(解析:DBMS_STATS 包已经扩展到包括与 advisor 交互的例程,答案 F 是对的;C 答案是会
给出建议;)
Reference: https://oracle-base.com/articles/12c/optimizer-statistics-advisor-12cr2
54、You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
A. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
B. All non-Ora
扫一扫
1562
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
