Re: autotrace and live plan

From: kyle Hailey <>
Date: Thu, 3 Sep 2009 09:30:46 -0700
Message-ID: <>

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 <> 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

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

Original text of this message