Re: xplan row source 9i

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 10 Dec 2004 09:55:13 -0800
Message-ID: <bf463804121009555be1b44d@mail.gmail.com>

Barbara,

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.

HTH Jared

On Fri, 10 Dec 2004 10:18:03 -0700, Barbara Baker <barb.baker_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 10 2004 - 11:56:14 CST