RE: Mysterious FILTER operation ;)

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 4 Jan 2005 11:07:18 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650207A383@25exch1.vicorpower.vicr.com>

Try this, course you'll have to replace the sql_address & hash values:=20

select lpad(operation||' '||options||'
'||object_owner||'.'||object_name||' ',
((nvl(parent_id,-1)*3)+3)+length(operation||' '||options||' '||object_owner||'.'||object_name))
from v$sql_plan where address =3D 'C0000000310B2AE0' and hash_value =3D '2879778763'

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Steven Patenaude [mailto:spatenau_at_gmail.com]=20 Sent: Tuesday, January 04, 2005 11:02 AM To: niall.litchfield_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Mysterious FILTER operation ;)

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?

>=20

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

>=20

> --
> Niall Litchfield

In some sense I wonder why it took so long for this view to show up.=20 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
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 04 2005 - 10:02:27 CST