概述
Oracle数据库中平均事务响应时间的计算公式
注： 该计算公式取自：白鳝<>，p316页
Top 5 Timed Events
Event
Waits
Time(s)
Avg Wait(ms)
% Total Call Time
Wait Class
direct path read
327,284
15,555
48
86.4
User I/O
CPU time
1,093
6.1
db file sequential read
283,101
509
2
2.8
User I/O
db file scattered read
99,520
180
2
1.0
User I/O
enq: TX - row lock contention
274
133
485
.7
Application
Wait Events
s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)
Event
Waits
%Time -outs
Total Wait Time (s)
Avg wait (ms)
Waits /txn
direct path read
327,284
0.00
15,555
48
32.66
db file sequential read
283,101
0.00
509
2
28.25
db file scattered read
99,520
0.00
180
2
9.93
enq: TX - row lock contention
274
98.91
133
485
0.03
log file sync
6,791
0.00
93
14
0.68
control file sequential read
16,168
0.00
91
6
1.61
log file parallel write
7,816
0.00
82
10
0.78
name-service call wait
1,199
0.42
68
57
0.12
以"direct path read"这个等待事件为例子来计算：
A---"direct path read" 的 Total Wait Time(以ms来计算)为15555*1000=15555000ms
B---"direct path read" 的 Waits 为327284
C---"direct path read" 的 Waits /txn 为32.66
D---"direct path read" 的 % Total Call Time 为 86.4%=0.864
平均事务响应时间=A/B*C/D=15555000/327284*32.66/0.864=1796.584626 ms
最后
以上就是光亮荷花为你收集整理的oracle数据库响应时间,Oracle数据库中平均事务响应时间的计算公式的全部内容，希望文章能够帮你解决oracle数据库响应时间,Oracle数据库中平均事务响应时间的计算公式所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复