今天检查彩民村的数据库健康状态,发现CPU使用率非常高,而且这个时间点的业务并不是很忙,开发人员也没有对数据库做大的操作。
分析AWR发现占用资源比较大的sql很多都是重复的
Top 5 Timed Events
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
CPU time |
| 20,956 |
| 51.4 |
|
read by other session | 32,208,585 | 3,680 | 0 | 9.0 | User I/O |
db file scattered read | 32,013,721 | 2,214 | 0 | 5.4 | User I/O |
db file sequential read | 42,658,212 | 1,100 | 0 | 2.7 | User I/O |
latch: cache buffers chains | 945,865 | 955 | 1 | 2.3 | Concurrency |