（219）You executed the following PL/SQL block successfully:

VARIABLE tname VARCHAR2(20)

BEGIN

dbms_addm.insert_finding_directive(NULL, DIR_NAME=>'Detail CPU Usage',

FINDING_NAME=>'CPU Usage', MIN_ACTIVE_SESSIONS=>0,

MIN_PERC_IMPACT=>90);

:tname := 'database ADDM task4';

dbms_addm.analyze_db(:tname, 150, 162);

END;

/

-- Then you executed the following command:

SQL>SELECT dbms_addm.get_report(:tname)FROM DUAL;

The above command produces Automatic Database Diagnostic Monitor(ADDM) analysis ________________.

A. with the CPU Usage finding if it is less than 90

B. without the CPU Usage finding if it is less than 90

C. with the CPU Usage finding for snapshots below 90

D. with the CPU Usage finding for snapshots not between 150 and 162

答案：（B）

解析：

DBMS_ADDM.INSERT_FINDING_DIRECTIVE

min_perc_impact, 在分析期间找到的结果相对于总的数据库时间的最小的"percent impact"

如果找到的影响小于这个值,则会从ADDM结果中过滤掉

ITPub博客

Oracle 11G OCP 1Z0-053 219