Re: xplan row source 9i

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: barb.baker@xxxxxxxxx
  • Date: Fri, 10 Dec 2004 09:55:13 -0800


If the 8i execution plan is from explain plan ( either manually
or from tkprof ), it may not be the actual execution plan.

8i tkprof runs 'explain plan' under the covers, which may
not actually be how the query was executed.

You use 9i tkprof to process an 8i trace file.  The 9i version
of tkprof will use the stat lines in the trace file to display the
execution plan.



On Fri, 10 Dec 2004 10:18:03 -0700, Barbara Baker <barb.baker@xxxxxxxxx> wrote:
> Chris:
> The explain plans are the same for 8i and 9i.  What I do not have is a
> full-up trace for 8i.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: