MIME-Version: 1.0
In-Reply-To: <304F58144267C5439E733532ABC9A3A11403936A@USA0300MS02.na.xerox.net>
References: <304F58144267C5439E733532ABC9A3A11403936A@USA0300MS02.na.xerox.net>
Date: Thu, 2 Feb 2012 15:21:33 -0600
Message-ID: <CAGWRspY8qREL3ay2x+NfwSumz2ixzpGm-MXiB8PVBrXNcJiTkA@mail.gmail.com>
Subject: Re: Enforcing plan via SQL plan baseline
From: Mihajlo Tekic <mihajlo.tekic@gmail.com>
To: Amir.Hameed@xerox.com
Cc: oracle-l@freelists.org
Content-type: text/plain
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: mihajlo.tekic@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@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