Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Mysterious FILTER operation ;)
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
>=20
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-lReceived on Tue Jan 04 2005 - 10:02:27 CST
![]() |
![]() |