Subject: "class slave wait" is the top wait event on AWR snapshot

最新推荐文章于 2021-04-03 11:01:38 发布

cnw8259

最新推荐文章于 2021-04-03 11:01:38 发布

阅读量331

点赞数

文章标签：数据库

前两天看到一份sp报告，在wait events事件中，有：

                                                                        Avg
                                                     Total Wait   wait    Waits
Event                               Waits   Timeouts   Time (s)   (ms)     /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file sequential read         4,490,735          0     14,958      3 3,024.1
control file parallel write         5,256          0        179     34      3.5
db file scattered read             51,799          0        100      2     34.9
class slave wait                       10         10         51   5117      0.0

看到有class slave wait等待avg wait（ms）居然是5117，一直没弄明白为啥能这么高？？

找了几天，最后想起来metalink上search下，居然发现是bug：

Applies to:

Enterprise Manager for RDBMS - Version: 10.1.0.3.0
This problem can occur on any platform.

Symptoms

"class slave wait" is the top wait event on AWR snapshot.
It is grouped under wait class "other"

Output of ADDM reports for these AWR snapshots:

FINDING 1: 100% impact (3431 seconds)
-------------------------------------
Wait class "Other" was consuming significant database time.

   NO RECOMMENDATIONS AVAILABLE

   ADDITIONAL INFORMATION: Database latches in the "Other" wait class were not
      consuming significant database time.