Re: Enforcing plan via SQL plan baseline
Date: Tue, 7 Feb 2012 09:45:26 +0530
While testing DBMS_SPM I found that if we use alias in query and copy that plan to original statement, it will not work..Full article can be seen here
On Tue, Feb 7, 2012 at 1:17 AM, Jared Still <jkstill_at_gmail.com> wrote:
> On Mon, Feb 6, 2012 at 11:20 AM, Wolfgang Breitling
>> And you disabled the original (unhinted) plan? Did you follow the steps
>> Maria's blog ( http://blogs.oracle.com/**optimizer/tags/sql_plan_**
>> management <http://blogs.oracle.com/optimizer/tags/sql_plan_management>)?
I haven't had a problem substituting a different plan for a sql. My
>> problem is that Peoplesoft has too many sql where this technique is not
>> applicable ( because they use literals in sql ).
> Actually I did use Maria's blog as a reference.
> But, I don't think I disabled the original plan.
> Thanks Wolfgang, that's probably the step I was missing.