(BUG) AWR下DB TIME非常高 bug案例

来源：互联网发布：mac os sierra重新安装编辑：程序博客网时间：2024/04/27 15:38

今天巡检发现AWR的 DB TIME 非常高，明显存在不符合现实。

MOS发现该问题中了 Bug 17963187 : INCORRECT CPU USAGE IN 11.2.0.4

PROBLEM:
--------
very high CPU time reported

DIAGNOSTIC ANALYSIS:
--------------------
Actual CPU utilization is very low.Even CT doesn't report any slowness

Same issue is reported in the below bug

Bug 13846587 : INCORRECT CPU USAGE IN 11.2.0.3 VS 11.2.0.2

DB TIME的数据通过调用AIX的thread_cputime()函数获得。

目前操作系统的版本是：6100-06-05-1115

对应中了AIX的bug，IV35038: THREAD_CPUTIME() RETURNS INCORRECT VALUES APPLIES TO AIX 6100-06

Wrong cpu usage information will be returned by the OS call thread_cputime() due to an OS bug

该bug会影响DB TIME有关报表的准确性，暂时未发现有其他影响。

IBM官网，该bug的信息与补丁

http://www-01.ibm.com/support/docview.wss?uid=isg1IV35038

另可参考MOS,(ID 1631769.1)

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=547630631116765&id=1631769.1&displayIndex=4&_afrWindowMode=0&_adf.ctrl-state=7ssnrkw5u_138#SYMPTOM

1 0