Page 1 of 1

You executed the following PL/SQL block successfully:VARIABLE tname VARCHAR2(20)BEGIN -dbms_addm.insert_finding_directiv

Posted: Wed Jun 07, 2023 6:11 am
by answerhappygod
You executed the following PL/SQL block successfully:VARIABLE tname VARCHAR2(20)BEGIN -dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage1,FINDING_NAME=>'CPU Usage1,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