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