单选题The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of

题目内容(请给出正确答案)

单选题

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）

Create two custom ADDM tasks.

Modify the AWR snapshot time interval to two hours.

Create a new scheduler window for a time period of two hours.

Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?（）A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.

点击查看答案
第2题

Which setting enables the baselines by default in Oracle Database 11g?()A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

点击查看答案
第3题

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.Which statement describes the consequence?()A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

点击查看答案
第4题

You executed the following PL／SQL block successfully:The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.()A. with the CPU Usage finding if it is less than 90B. without the CPU Usage finding if it is less than 90C. with the CPU Usage finding for snapshots below 90D. with the CPU Usage finding for snapshots not between 150 and 162

点击查看答案
第5题

下面有关Automatic Database Diagnostic Monitor(ADDM)的描述中,那两项是正确的?()A.ADDM仅提供诊断分析，不提供建议B.ADDM分析结果存放在Automatic Workload Repository中C.ADDM是MMON进程在每次awr快照收集后自动运行D.ADDM可以调用其它建议如果需要，但是不会产生推荐建议E.ADDM至少需要4个awr快照进行分析

点击查看答案
第6题

Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）A、The ADDM requires at least four AWR snapshots for analysis.B、The ADDM runs after each AWR snapshot is collected automatically by MMON.C、The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.D、The ADDM analysis provides only diagnostic information but does not provide recommendations.E、The ADDM calls other advisors if required， but does not provide recommendations about the advisors.

点击查看答案
第7题

You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）A、Memory AdvisorsB、Segment AdvisorsC、SQL Tuning and Access AdvisorsD、Automated Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）

点击查看答案

The Automatic Database Diagnostic Monitor (ADDM) analysis ru

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容