Re: autotrace and live plan

From: kyle Hailey <kylelf_at_gmail.com>
Date: Thu, 3 Sep 2009 09:30:46 -0700
Message-ID: <6f373fd20909030930h73097040of174b902204b84b4_at_mail.gmail.com>

Thanks to everyone who replied.Here's a good thread on Jonathan Lewis' blog on this subject

http://jonathanlewis.wordpress.com/testing-autotrace/#comment-34301 <http://jonathanlewis.wordpress.com/testing-autotrace/#comment-34301>

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.
>
> Best
> Kyle
> http://perfvision.com
> http://oraclemonitor.com
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 03 2009 - 11:30:46 CDT