Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: tkprof statisitics
I am looking at sorts ( both disk and memory ) and I/Os
Mark D Powell wrote:
> Prasath wrote:
> > Is it possible to get the 'statistics' from a tkprof analysis as we get
> > them with explain plan?
>
> What version of Oracle? What specific statistics are you interested
> in?
>
> The tkprof report includes numerous statistics besides the parse,
> fetch, and execute counts along with the number of physical and logical
> IO plus rows returned for a query it includes such items as "db file
> scattered read" and "SQL*Net message to client". It also includes the
> explain plan. What more that would be of use do you want?
>
> HTH -- Mark D Powell --
Received on Wed Jul 26 2006 - 09:22:19 CDT