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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tuning I/O-related wait - Metalink Note: 223117.1

RE: Tuning I/O-related wait - Metalink Note: 223117.1

From: Andy Rivenes <arivenes_at_llnl.gov>
Date: Tue, 09 Nov 2004 13:38:53 -0800
Message-Id: <6.0.0.22.2.20041109132018.029bf268@mail.llnl.gov>


At this level (e.g. "system") response time is a misnomer. What you have is elapsed time and the "capacity" to consume service time up to the total, or elapsed time, of the interval measured. Elapsed time at this level cannot be accurately "calculated" by adding "service time" and "wait time". Elapsed time is calculated as the difference between measurement intervals. Wait time measurements at the system level are flawed at best due to interval boundary measurements and the capacity for "infinite" waiting (I believe Cary coined this term first). However, Lex is otherwise correct in my opinion, since the "wait time" will generally skew high and since it is only a fraction of the "service time" it is probably not an overriding issue. Of course, now we're venturing from workload measurement to performance tuning, and for that you need to look at the "process" you're concerned about and not focus on system level workload measurements.

At 08:28 AM 11/9/2004, Lex de Haan wrote:
>
>See in line ...
>
>Lex.
>
>
>
>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
>
>CPU time = 94.52% = 379,623 / 358,806
>direct path read = 2.85% = 10,827 / 358,806

Andy Rivenes
Email: arivenes_at_llnl.gov

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 09 2004 - 15:31:52 CST

Original text of this message

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