Re: Mysterious FILTER operation ;)
- From: Steven Patenaude <spatenau@xxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- Date: Tue, 4 Jan 2005 10:02:07 -0600
On Tue, 4 Jan 2005 15:28:45 +0000, Niall Litchfield
<niall.litchfield@xxxxxxxxx> wrote:
> > The only opportunity to see real explain plan is to check V$SQL_PLAN, by
> > my opinion. Or I am wrong?
>
> A problem in 8i, and in 10 you have DBA_HIST_SQL_PLAN for historical
> plans. The latter is in principle great for folks like me who have
> long suggested that a change in execution plan is worth investigating
> secure in the knowledge that determining whether a plan has changed or
> not is somewhat difficult in earlier versions...
>
> --
> Niall Litchfield
In some sense I wonder why it took so long for this view to show up.
It has been needed for a long time.
Does anyone have a good select statement that prints the plan from
v$sql_plan nicely?
Thanks,
Steven Patenaude
--
//www.freelists.org/webpage/oracle-l
Other related posts:
