Re: ** outline change
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: riyaj.shamsudeen@xxxxxxxxx
- Date: Wed, 18 Mar 2009 09:59:19 -0700 (PDT)
Riyaj,
Yes. I had seen this note. It is applicable for when we
have two outlines one good one bad and then exchange. In my case : I
cannot change query etc and create outline since it is indirect query.
So I need to create outline and then change it. Another problem is my
OEM is not working for which I sent another mail. So any help is
welcome. Thanks
--- On Wed, 3/18/09, Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx> wrote:
From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
Subject: Re: ** outline change
To: ajoshi977@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Date: Wednesday, March 18, 2009, 11:07 AM
Hi Joshi
Have you reviewed document 730062.1? That document is the correct way to
manipulate outlines.
--
Cheers
Riyaj Shamsudeen
Principal DBA,
Ora!nternals - http://www.orainternals.com
Specialists in Performance, Recovery and EBS11i
Blog: http://orainternals.wordpress.com
On Wed, Mar 18, 2009 at 9:12 AM, A Joshi <ajoshi977@xxxxxxxxx> wrote:
Hi,
I want to update a stored outline to change the join method. Is
there a way it can be done from sqlplus instead of from OEM or tool.
Using just unix sqlplus access. I looked at DBMS_OUTLN package but
nothing in it. I do see tables like outln.ol$hints and the outline in
it but I do not want to do a sqlplus update on it without knowing the
full impact. I cannot change the query with hint etc since it is a
indirect query. So I cannot give hint etc and exchange plan. Thanks for
help. In TOAD : it says there is outline management but I cannot find
it. Thanks
Other related posts:
