RE: Mysterious FILTER operation ;)

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <spatenau@xxxxxxxxx>, <niall.litchfield@xxxxxxxxx>
  • Date: Tue, 4 Jan 2005 11:07:18 -0500

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||'
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@xxxxxxxxx]=20
Sent: Tuesday, January 04, 2005 11:02 AM
To: niall.litchfield@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Mysterious FILTER operation ;)

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

Steven Patenaude

Other related posts: