Re: Enforcing plan via SQL plan baseline

From: amit bansal <amit.bansal82_at_gmail.com>
Date: Tue, 7 Feb 2012 09:45:26 +0530
Message-ID: <CAB8JqBZgkU5bzfCHeeRJqrj7CbH-bZUMReVrR1nF0hr-CS8Zjg_at_mail.gmail.com>

hi,
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

http://askdba.org/weblog/2011/12/plan-stability-using-sql-profiles-and-sql-plan-management/

Regards
Amit

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
> <centrex_at_centrexcc.com>wrote:
>> And you disabled the original (unhinted) plan? Did you follow the steps
in
>> 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.
>
> Jared
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 06 2012 - 22:15:26 CST