Oracle 11G OCP 1Z0-053 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?

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.


答案:(B)

解析:

使用DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE

使用这个过程创建一个指令阻止ADDM针对特定的段创建一个操作来"run Segment Advisor"

这个指令可以针对特定的任务来创建(只有当该任务处于INITIAL状态); 也可以针对所有后面创建的ADDM任务。



请使用浏览器的分享功能分享到微信等