Re: Enforcing plan via SQL plan baseline
From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 6 Feb 2012 11:47:16 -0800
Message-ID: <CAORjz=NUwd_dXV=JiwjjDYsmKdAd6iVuJ5YaHg_9qxWnN2X2Yw_at_mail.gmail.com>
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 ).
>
Date: Mon, 6 Feb 2012 11:47:16 -0800
Message-ID: <CAORjz=NUwd_dXV=JiwjjDYsmKdAd6iVuJ5YaHg_9qxWnN2X2Yw_at_mail.gmail.com>
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-lReceived on Mon Feb 06 2012 - 13:47:16 CST