Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: cpu time and query column in tkprof output
> 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-lReceived on Wed Feb 02 2005 - 17:38:43 CST