OCP考试第18题

18. You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task.

To view the ADDM report, you use the following command:

SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;

You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments. What would you do to achieve this?

你想要ADDM输出关于segment的建议

 

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.

 

 

 

知识点：

ADDM是Oracle一个实现性能自我诊断的最佳利器。它依赖于AWR，也就是说ADDM要诊断，必要要有诊断的依据。

要使用ADDM，两个重要的参数应进行正确的配置。

  statistics_level：该参数建议设置为TYPICAL

  control_management_pack_access：该参数建议设置为DIAGNOSTIC+TUNING，及诊断和优化包都被使用。

ADDM采样 @?/rdbms/admin/addmrpt.sql  

主要哪些问题导致了过高的DB Time 占用，并提供建议。

参考：https://blog.csdn.net/leshami/article/details/70859672

GET_ASH_QUERY Function	Returns a string containing the SQL text of an ASH query identifying the rows in ASH with impact for the finding
GET_REPORT Function	Retrieves the default text report of an executed ADDM task
INSERT_FINDING_DIRECTIVE Procedure	Creates a directive to limit reporting of a specific finding type.
INSERT_PARAMETER_DIRECTIVE Procedure	Creates a directive to prevent ADDM from creating actions to alter the value of a specific system parameter
INSERT_SEGMENT_DIRECTIVE Procedure	Creates a directive to prevent ADDM from creating actions to "run Segment Advisor" for specific segments
INSERT_SQL_DIRECTIVE Procedure	Creates a directive to limit reporting of actions on specific SQL

可以提供Creates a directive to prevent ADDM from creating actions to "run Segment Advisor" for specific segments

 

 

答案：B