Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> calculate % of response time components
Hello Gurus,
In metalink note : 223117.1 - Tuning I/O related waits, I extracted the following, but, I couldn't understand the calculation made to get the % result. The extract of the note are as follows:
Top 5 Wait Events ~~~~~~~~~~~~~~~~~ Wait % Total Event Waits Time (cs) Wt Time ------------------------ -------------------- ------------ ------------ ------- direct path read 4,232 10,827 52.01 db file scattered read 6,105 6,264 30.09 direct path write 1,992 3,268 15.70 control file parallel write 893 198 .95 db file parallel write 40 131 .63 ------------------------ ------------------------ ------------- Based on this listing we may be tempted to immediately start looking at the causes between the
'direct path read' and
'db file scattered read'
waits and to try to tune them. This approach would not take into account
'Service Time'.
Here is the statistic that measures 'Service Time' from the same report: Statistic Total per Second per Trans ------------------------ --------- ---------------- ------------ ------------ CPU used by this session 358,806 130.5 12,372.6 Let's do some simple math from these figures:
'Wait Time' = 10,827 x
100% / 52,01% = 20,817 cs
'Service Time' = 358,806
cs
'Response Time' =
358,806 + 20,817 = 379,623 cs If we now calculate percentages for all the
'Response Time'
components: CPU time = 94.52% direct path read = 2.85% db file scattered read = 1.65% direct path write = 0.86% control file parallel write = 0.05% db file parallel write = 0.03%
Could any one tell me, how the calculations are made to get the % of each wait event in the above?
Best Regards,
Syed Jaffar Hussain
OCP, DBA Consultant
ITD/Systems Department/Database Section
Tel : 01 4042222 x 1020
Mobile : 0506446723
Visit us on www.alfransi.com.sa
====== Banque Saudi Fransi - Privacy Notice ======
This message is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
use of this information by persons or entities other than the intended
recipient is prohibited. If you have received this in error, please
contact the sender and delete the material from your computer. Any
opinions and other information contained in this message that do not
relate to the official business of Banque Saudi Fransi shall be
understood as neither given or endorsed by it. Although precautions
have been taken to ensure no viruses are present in this email, BSF
cannot accept responsibility for any loss or damage arising from the
use of this email or attachments.
====== Banque Saudi Fransi - Privacy Notice ======
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 21 2004 - 08:54:32 CDT
![]() |
![]() |