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: cpu time and query column in tkprof output

Re: cpu time and query column in tkprof output

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 02 Feb 2005 08:49:16 -0700
Message-ID: <4200F67C.50007@centrexcc.com>


Whenever I have done comparisons of different sql to produce the same result, the bytes sent via SQL*Net were always the same - maybe wrong, but at least consistently wrong.

Cary Millsap wrote:
> 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.
>
>

-
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 02 2005 - 10:52:03 CST

Original text of this message

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