Re: tkprof statisitics

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 26 Jul 2006 07:11:15 -0700
Message-ID: <1153923075.091914.272950@p79g2000cwp.googlegroups.com>

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:11:15 CDT