RE: Negative wait time
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 2 Feb 2004 10:34:34 -0600
If you do this, you'll lose half of your "self-correcting" quantization
errors, which means they won't be self-correcting anymore.
Leave the numbers alone. Just label them correctly. It's not "Wait
time", it's "e - c", which is different.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Monday, February 02, 2004 10:13 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Negative wait time
Cary is certainly welcome to correct me if I'm wrong, but I think, since
it doesn't make logical sense to have negative wait time, you should
report 0 wait time and the negative time as "unaccounted for"....
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and
a sense of humor was provided to console him for what he is." --Horace
Walpole
-----Original Message-----
From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni@xxxxxxxx]=20
Sent: Monday, February 02, 2004 10:54 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Negative wait time
Thanks Cary, so is it okay to ignore negative wait times?
Raj
------------------------------------------------------------------------
-=3D
-------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Cary Millsap
Sent: Monday, February 02, 2004 10:48 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Negative wait time
Quantization error.
The error is greater on the 'c' statistic than any other, because it is
obtained by polling in 10,000-microsecond increments.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jamadagni, Rajendra
Sent: Monday, February 02, 2004 8:03 AM
To: Oracle List (E-mail)
Subject: Negative wait time
Okay it is Monday and I seem to have difficulty remembering stuff ...
I wrote a pl/sql procedure that analyzes a given trace file and produces
output like this ... but look at wait time ... why is it < 0 ??=3D20
wait =3D3D elapsed-cpu right? What am I missing? In case you are =
wondering
... this procedure (and its output) is based on Cary's paper 'LIO Vs
PIO' ... not precise, but should be pretty close.
SQL Hash Value : 98525727
SELECT count(distinct(us.Ut_Id)) Res_Prmpt
From yyyy ms, zzzz us
Where ms.Mg_Unit_Id =3D3D us.Ut_Id
And us.Pob_Id =3D3D :b4
and ( :b3 IS NULL OR us.Line_Number =3D3D :b3 )
And us.Monday_Dt between :b2 AND :b1
And us.Makegood =3D3D 'A'
And us.Reason_Cd <> -19
And ms.Mg_Unit_Type =3D3D 'P'
And us.Ut_Id Not In (Select ms1.Mg_Unit_Id
From xxxx ms1, yyyy mh
Where ms1.Mg_Number =3D3D mh.Mg_Number
And ms1.Mg_Unit_Type =3D3D 'M'
And mh.Mg_Pob_Id =3D3D :b4
And mh.Mg_Line_Number =3D3D us.Line_Number)
-------- Response Time --------
Action Count Rows Ela Time CPU Time Wait Time LIO Blocks PIO
Blocks
------ ------ --------- ---------- ---------- ---------- ----------
----------
PARSE 1 0 0.000 0.000 0.000 0
0
EXEC 51 0 0.004 0.010 -0.006 0
0
FETCH 51 51 0.450 0.390 0.060 9047
11
------ ------ --------- ---------- ---------- ---------- ----------
----------
TOTAL 103 51 0.454 0.400 0.054 9047
11
Any pointers are welcome, and yes please excuse me while I go have
another coffee.
Raj
------------------------------------------------------------------------
--------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
