Re: Mysterious FILTER operation ;)

From: Steven Patenaude <spatenau_at_gmail.com>
Date: Tue, 4 Jan 2005 10:02:07 -0600
Message-ID: <10644b9e0501040802479ff2ec@mail.gmail.com>

On Tue, 4 Jan 2005 15:28:45 +0000, Niall Litchfield <niall.litchfield_at_gmail.com> 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

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

Received on Tue Jan 04 2005 - 09:57:22 CST