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任务。