- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
4#
发表于 2013-7-26 11:04:20
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
row cache lock 54,392 129,530 2,381 42.8 Concurrency
latch: row cache objects 1,808,208 116,148 64 38.4 Concurrency
cursor: pin S wait on X 2,868,983 28,202 10 9.3 Concurrency
library cache pin 4,144 9,795 2,364 3.2 Concurrency
CPU time 7,991 2.6
大量解析类等待
Begin End
Buffer Cache: 12,592M 14,240M Std Block Size: 8K
Shared Pool Size: 7,824M 6,176M Log Buffer: 14,304K
shared pool发生了 7824=》 6176的收缩
latch row cache objects 主要体现在kqrbip ==》background release instance lock and invalidate parent object
row cache objects kqrbip 0 10,822 32,025
row cache objects kqreqd: reget 0 2,631 12,610
row cache objects kqrpre: find obj 0 1,173 30,024
row cache objects kqrso 0 870 15,993
row cache objects kqreqd 0 541 15,882
row cache objects kqrigt 0 281 9,409
SGA: MMAN sleep for component shrink 6 83.33 0 8 0.00
发生了约6次shrink
主要还是MMAN shrink shared pool 导致的row cache lock 及其他效应等待
|
|