- 最后登录
- 2016-6-27
- 在线时间
- 134 小时
- 威望
- 351
- 金钱
- 2586
- 注册时间
- 2012-3-16
- 阅读权限
- 60
- 帖子
- 188
- 精华
- 6
- 积分
- 351
- UID
- 309
|
1#
发表于 2013-5-24 22:50:22
|
查看: 2054 |
回复: 0
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Release RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
ZTEDM2 4110881531 ztedm2 1 10.2.0.4.0 NO dboss02
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 17376 07-May-13 03:59:49 119 4.8
End Snap: 17377 07-May-13 04:27:33 111 5.7
Elapsed: 27.73 (mins)
DB Time: 572.22 (mins)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
---------------------------- -------------- ------ ----------- ------- ---------
PX Deq Credit: send blkd 130,069 5.7 15,033 116 35.8
db file sequential read 240,299 .0 762 3 66.1
enq: TX - index contention 348 70.7 741 2130 0.1
row cache lock 9,439 .0 611 65 2.6
read by other session 65,577 .0 310 5 18.0
library cache lock 2,526 .0 241 95 0.7
buffer busy waits 900 .0 0 0 0.2
Buffer Pool Statistics DB/Inst: ZTEDM2/ztedm2 Snaps: 17376-17377
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
Free Writ Buffer
Number of Pool Buffer Physical Physical Buff Comp Busy
P Buffers Hit% Gets Reads Writes Wait Wait Waits
--- ---------- ---- -------------- ------------ ----------- ---- ---- ----------
D 4,989,059 100 297,162,188 330,333 555,363 0 0 67,060
K 11,874 N/A 0 0 0 0 0 0
R 11,874 100 152,582 0 0 0 0 0
-------------------------------------------------------------
在wait event里面buffer busy waits显示的值是900,但是在Buffer Pool Statistics里显示的值确是67060.
如果把wait event里面的read by other session和buffer busy waits加起来就接近这个数了。
那是否表示Buffer Pool Statistics里的buffer busy waits实际上等于buffer busy waits+read by other session呢? |
|