Re: Enforcing plan via SQL plan baseline

From: coskan gundogar <coskan_at_gmail.com>
Date: Wed, 15 Feb 2012 06:04:37 +0000
Message-ID: <CAGLGTvNDpGULBsk1fRsE9xc7z5LSy0yP9AGrX3oj3uxaFneAqQ_at_mail.gmail.com>

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
> <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 ).
> >
>
>
> 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
> it.
>
> Jared
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Wed Feb 15 2012 - 00:04:37 CST