From oracle-l-bounce@freelists.org Wed Feb 2 17:38:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j12NchVA010930 for ; Wed, 2 Feb 2005 17:38: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 j12Ncgem010926 for ; Wed, 2 Feb 2005 17:38:42 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2E0B86CC3C; Wed, 2 Feb 2005 17:37:46 -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 06740-08; Wed, 2 Feb 2005 17:37:46 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A43CF6CB5E; Wed, 2 Feb 2005 17:37:45 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=ji0g4ZpBhMEUqhqYRN0P2SpTphJuVDbtXpR5j7Hs8u9PmzYGK2p0Vi7AvWIXOG8RC0mmy2XkQ09vIxCVMmDkYGEQdRYberSIDAXGf9JWw6ByNCJyAhTh/AOkJbS7FKPC+/IHEmnr5ULANNf0yulLT9ua+jqaVakxKUm5HD8u3S0= Message-ID: Date: Thu, 3 Feb 2005 04:36:04 +0600 From: Egor Starostin To: cary.millsap@hotsos.com Subject: Re: cpu time and query column in tkprof output Cc: breitliw@centrexcc.com, yasbs@kocbank.com.tr, oracle-l@freelists.org In-Reply-To: <003501c50936$03e5e850$6500a8c0@CVMLAP02> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <4200E504.5020200@centrexcc.com> <003501c50936$03e5e850$6500a8c0@CVMLAP02> X-archive-position: 15710 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: egorst@gmail.com Precedence: normal Reply-To: egorst@gmail.com 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: > I'm almost positive that the byte counts on these two statistics are > incorrect anyway... At least, the byte count on these two events as > published in the 10046 output is ALWAYS incorrect (they always say p2=1, > which is always wrong). You can verify this yourself with strace. autotrace in sqlplus (looks like Yasin provided autotrace's results) is not so wrong as 10046 event. At least, strace shows the similar numbers to autotrace ones. -- Egor http://www.oracledba.ru/orasrp/ Free Oracle Session Resource Profiler -- http://www.freelists.org/webpage/oracle-l