Oracle OCP 1Z0 053 Q219(dbms_addm.insert_finding_directive)

abstractcyj發表於2016-04-03
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
Answer: B

參考:http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_addm.htm#ARPLS65063

INSERT_PARAMETER_DIRECTIVE Procedure

This procedure creates a directive to prevent ADDM from creating actions to alter the value of a specific system parameter. The directive can be created for a specific task (only when the task is inINITIAL status), or for all subsequently created ADDM tasks (such as a system directive).


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2074540/,如需轉載,請註明出處,否則將追究法律責任。

相關文章