Re: autotrace and live plan
Date: Thu, 3 Sep 2009 09:30:46 -0700
Thanks to everyone who replied.Here's a good thread on Jonathan Lewis' blog on this subject
On Tue, Sep 1, 2009 at 10:57 AM, kyle Hailey <kylelf_at_gmail.com> wrote:
> Does autotrace ever show the live plan, ie the plan from v$sql_plan?I
> traced autotrace on 9iR2 and 10gR2 and in both cases they use "explain plan"
> to generate the explain plan.
> I guess that fine since theoretically within my same session the calculated
> execution plan, ie "explain plan", would have to be the same as the actual
> executed plan, but with v$sql_plan in place, I somehow find it disconcerting
> that the plan isn't extracted from v$sql_plan.