ocp-420

最新推荐文章于 2025-09-12 18:07:57 发布

翻译最新推荐文章于 2025-09-12 18:07:57 发布 · 815 阅读

文章标签：

#oracle

OCP-1Z0-053 专栏收录该内容

674 篇文章

订阅专栏

本文探讨了在数据库管理系统中成功执行PL/SQL块后，如何通过ADDM分析来评估CPU使用率，特别关注于在指定阈值90%下的分析表现。详细解释了SQL命令的执行流程及其产生的结果，强调了当CPU使用率低于90%时，ADDM分析的处理方式。

QUESTION NO: 420
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

上述命令产生自动数据库诊断监视（ ADDM）分析。

B.没有发现CPU使用率小于90