Re: Enforcing plan via SQL plan baseline

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@xxxxxxxxx> wrote:

> On Mon, Feb 6, 2012 at 11:20 AM, Wolfgang Breitling
> <centrex@xxxxxxxxxxxxx>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


Other related posts: