Re: Enforcing plan via SQL plan baseline

From: Mihajlo Tekic <mihajlo.tekic_at_gmail.com>
Date: Thu, 2 Feb 2012 15:21:33 -0600
Message-ID: <CAGWRspY8qREL3ay2x+NfwSumz2ixzpGm-MXiB8PVBrXNcJiTkA_at_mail.gmail.com>



Have you tried to fix the plan that you want to be used. (Fixed Plan Baseline)
http://docs.oracle.com/cd/B28359_01/server.111/b28274/optplanmgmt.htm#BABICJBG

~Mihajlo

On Thu, Feb 2, 2012 at 2:56 PM, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:

> Folks,
> When using SQL plan baseline, is it possible to instruct the optimizer
> to use a baseline that has sub-optimal plan than the one it is currently
> using. For example, a SQL statement, which cannot be altered because it
> is coming out of a COTS application, is currently using an index scan
> and I would like to force it to use FTS. I have tried forcing the
> optimizer to use the SQL plan baseline but it keeps using the index path
> and hence ignoring the plan baseline. Any feedback will be appreciated.
>
>
>
> Thanks
>
> Amir
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 02 2012 - 15:21:33 CST

Original text of this message