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?

Steven Patenaude

Other related posts: