oracle服务器cpu 100,【Oracle服务器cpu100%调查日记】Oracle bug(cursor: mutex S)

最近一周服务器再一次发现了cpu100%的问题，看来上次对sql语句的优化没有彻底根治这个问题。话不多说，继续开始调查这个问题。

首先查看了当天发生问题的一小时内的AWR报告：

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.

%Total – CPU Time as a percentage of Total DB CPU

%CPU – CPU Time as a percentage of Elapsed Time

%IO – User I/O Time as a percentage of Elapsed Time

Captured SQL account for 1.9% of Total CPU Time (s): 9,545

Captured PL/SQL account for 0.2% of Total CPU Time (s): 9,545

CPU Time (s)

Executions

CPU per Exec (s)

%Total

Elapsed Time (s)

%CPU

%IO

SQL Id

SQL Module

SQL Text

67.58

0.71

80.38

84.08

insert into sys.aud$( sessioni…

58.84

23

2.56

0.62

180.38

32.62