Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> calculate % of response time components

calculate % of response time components

From: <SJHussain_at_alfransi.com.sa>
Date: Tue, 21 Sep 2004 16:58:53 +0300
Message-ID: <OF9FC57489.E5931D0E-ON43256F16.004C5CF3-43256F16.004CCD4E@AlFransi.com.sa>

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-l
Received on Tue Sep 21 2004 - 08:54:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US