From oracle-l-bounce@freelists.org Thu Mar 31 11:50:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2VHohnk031881 for ; Thu, 31 Mar 2005 11:50:43 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j2VHogem031876 for ; Thu, 31 Mar 2005 11:50:43 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AFEA98B40A; Thu, 31 Mar 2005 11:48:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20353-08; Thu, 31 Mar 2005 11:48:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 34A5D8B3E0; Thu, 31 Mar 2005 11:48:41 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: TKPROF output Date: Thu, 31 Mar 2005 10:46:38 -0600 Message-ID: <27C3FCA54F61C34389325FD99A0D60CC0449ABC3@pscdalpexch50.perotsystems.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: TKPROF output Thread-Index: AcU2ETUID5X6FjvpT+ScIbNtb+euFQ== From: "Ehresmann, David" To: Content-Transfer-Encoding: 8bit X-archive-position: 17929 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: David.Ehresmann@ps.net Precedence: normal Reply-To: David.Ehresmann@ps.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 33531 1.471086152896.75 175 546 36959 33531 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 33534 1.471086152896.75 175 546 36959 33531 Why does TKPROF stream the EXECUTE line and put the CPU and ELAPSED timings together. This is the only place in the file that this is done. How do you separate them? Thanks, David Ehresmann -- http://www.freelists.org/webpage/oracle-l