oracle 下载账号密码是什么Oracle数据库中平均事务响应时间的计算公式

发表于2019年10月19日由oracle

Oracle数据库中平均事务响应时间的计算公式

注： 该计算公式取自：白鳝 <<oracle优化日记>>，p316页

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

direct path read327,28415,5554886.4User I/OCPU time 1,093 6.1 db file sequential read283,10150922.8User I/Odb file scattered read99,52018021.0User I/Oenq: TX – row lock contention274133485.7Application

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 read327,2840.0015,5554832.66db file sequential read283,1010.00509228.25db file scattered read99,5200.0018029.93enq: TX – row lock contention27498.911334850.03log file sync6,7910.0093140.68control file sequential read16,1680.009161.61log file parallel write7,8160.0082100.78name-service call wait1,1990.4268570.12

    以"direct path read"这个等待事件为例子来计算：A---"direct path read" 的  Total Wait Time（以ms来计算）为15555*1000=15555000msB---"direct path reoracle账号ad" 的   Waits 为327284C---"direct path read" 的   Waits /txn   为32.66D---"direct path read" 的   % Total Call Time 为 86.4%=0.864平均事务响应时间=A/B*C/D=15555000/327284*32.66/0.864=1796.584626 ms

    • 此条目发表在oracle metalink账号分类目录，贴了标签。将固定链接加入收藏夹。