How calculate Response Time components from statspack ?
I have been used 9.2.0.4. From Troubleshooting I/O-related waits [ID 223117.1] , from Example 1: Statspack before Oracle9i Release 2 section, I can not understand how Oracle can calculate percentages for all the 'Response Time' components such as (red text):
CPU time = 94.52%<br/>direct path read = <font color="#ff0000">2.85%<br/></font>db file scattered read = <font color="#ff0000">1.65%<br/></font>direct path write = <font color="#ff0000">0.86%<br/></font>control file parallel write = <font color="#ff0000">0.05%<br/></font>db file parallel write = <font color="#ff0000">0.03%</font>
<font face="Arial"> Can anyone show me methods to calculate these numbers ? Or I use 9.2.0.4 so there are others to calculate results ?</font>