题目
A.只有操作系统的时间和执行计划执行的统计信息被收集
B.手动无法执行DBMS_WORKLOAD_REPOSITORY生成snapshot
C.数据库自动收集需要表的统计信息为优化器使用
D.awr资料库的snapshot不会自动生成
E.优化器自动收集统计信息
第1题
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
第2题
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
第3题
A.VIEWS
B.SCHEMATA
C.COLUMNS
D.STATISTICS
第4题
A.使用set statistics io语句
B.使用set statistics time语句
C.使用set statistics CPU语句
D.使用set statistics time and CPU语句
第5题
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.
B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.
C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.
D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!