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: Egor Starostin <egorst_at_gmail.com>
Date: Thu, 3 Feb 2005 04:36:04 +0600
Message-ID: <f0fc91970502021436283a9d20@mail.gmail.com>


> 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
Received on Wed Feb 02 2005 - 17:38:43 CST

Original text of this message

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