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博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1263993/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1263993/