Re: Enforcing plan via SQL plan baseline
Date: Wed, 15 Feb 2012 06:04:37 +0000
Are you sure the underlying physical structure is %100 same asof time you created the baseline ?
I wonder what happens if you create a profile for the outline info you hinted with coe method.
Sent from my mobile device
On Feb 15, 2012 2:01 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 ).
> Got back to this today.
> Still no joy. The only baseline in SPM is the one I want to be used,
> and Oracle is clearly rejecting it.
> 10053 says something to the effect "SPM: cannot reproduce" - I forget the
> exact text at the moment.
> The only difference in the SQL used to capture the plan was the addition of
> an index hint.
> Currently reading one of Kerry's blog entries that may shed some light on