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 ____.

Question

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 ____.

Accepted Answer

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

Answer

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

Answer

C. with the CPU Usage finding for snapshots below 90

Answer

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

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'…

Question

Options

How the community answered

Community Discussion