Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i12GQw207820 for ; Mon, 2 Feb 2004 10:26:58 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i12GQuo07811 for ; Mon, 2 Feb 2004 10:26:56 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 16E5039532B; Mon, 2 Feb 2004 11:20:45 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 02 Feb 2004 11:19:36 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from aphrodite.espn.com (aphrodite.espn.com [204.149.192.11]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CFEBF39506A for ; Mon, 2 Feb 2004 11:19:22 -0500 (EST) Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Subject: RE: Negative wait time Date: Mon, 2 Feb 2004 11:26:03 -0500 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Negative wait time Thread-Index: AcPppI6b+L+mPaYmTtahsHRT/rf7UgAAB2BgAACqoHAAAHknAA== From: "Jamadagni, Rajendra" To: X-OriginalArrivalTime: 02 Feb 2004 16:26:04.0423 (UTC) FILETIME=[40E88170:01C3E9A9] X-archive-position: 555 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Rajendra.Jamadagni@espn.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Makes sense ... Thanks Mark. 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 ! -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Bobak, Mark Sent: Monday, February 02, 2004 11:13 AM To: oracle-l@freelists.org 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@espn.com]=3D20 Sent: Monday, February 02, 2004 10:54 AM To: oracle-l@freelists.org Subject: RE: Negative wait time Thanks Cary, so is it okay to ignore negative wait times? Raj ------------------------------------------------------------------------ -=3D3D ------- 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Cary Millsap Sent: Monday, February 02, 2004 10:48 AM To: oracle-l@freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org] 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 ??=3D3D20 wait =3D3D3D elapsed-cpu right? What am I missing? In case you are =3D 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 =3D3D3D us.Ut_Id And us.Pob_Id =3D3D3D :b4 and ( :b3 IS NULL OR us.Line_Number =3D3D3D :b3 ) And us.Monday_Dt between :b2 AND :b1 And us.Makegood =3D3D3D 'A' And us.Reason_Cd <> -19 And ms.Mg_Unit_Type =3D3D3D 'P' And us.Ut_Id Not In (Select ms1.Mg_Unit_Id From xxxx ms1, yyyy mh Where ms1.Mg_Number =3D3D3D mh.Mg_Number And ms1.Mg_Unit_Type =3D3D3D 'M' And mh.Mg_Pob_Id =3D3D3D :b4 And mh.Mg_Line_Number =3D3D3D = 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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------