|
原帖由 anlinew 于 2007-12-26 14:33 发表
这个好像讨论过一次
我认为 这里的avg waits跟系统实际IO能力关系不大
大家可以随便找一个系统的report来看看,很可能这个指标为1或者0,能说明系统的IO能力更强?
能否给个链接?
另外我这个系统企不是io很差?
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 115,476.38 22,667.12
Logical reads: 41,351.67 8,117.01
Block changes: 585.41 114.91
Physical reads: 5,997.50 1,177.26
Physical writes: 54.30 10.66
Avg
Total Wait wait Waits
Event Waits Timeouts Time (cs) (ms) /txn
---------------------------- ------------ ---------- ----------- ------ ------
global cache cr request 2,668,756 503 11,937,913 45 145.5
library cache lock 129,745 6,703 3,180,590 245 7.1
db file scattered read 1,196,747 0 2,160,688 18 65.3
buffer busy due to global ca 78,076 45 1,714,316 220 4.3 |
|