Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-type: text/plain
Subject: RE: Enforcing plan via SQL plan baseline
Date: Thu, 2 Feb 2012 16:26:29 -0500
Message-ID: <304F58144267C5439E733532ABC9A3A1140393C8@USA0300MS02.na.xerox.net>
In-Reply-To: <CAGWRspY8qREL3ay2x+NfwSumz2ixzpGm-MXiB8PVBrXNcJiTkA@mail.gmail.com>
Thread-Topic: Enforcing plan via SQL plan baseline
References: <304F58144267C5439E733532ABC9A3A11403936A@USA0300MS02.na.xerox.net> <CAGWRspY8qREL3ay2x+NfwSumz2ixzpGm-MXiB8PVBrXNcJiTkA@mail.gmail.com>
From: "Hameed, Amir" <Amir.Hameed@xerox.com>
To: "Mihajlo Tekic" <mihajlo.tekic@gmail.com>
Cc: <oracle-l@freelists.org>
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: Amir.Hameed@xerox.com

Thanks Mihajlo...I have tried that as well but the outcome was the same.
 

From: Mihajlo Tekic [mailto:mihajlo.tekic@gmail.com] 
Sent: Thursday, February 02, 2012 4:22 PM
To: Hameed, Amir
Cc: oracle-l@freelists.org
Subject: Re: Enforcing plan via SQL plan baseline

 
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#BA
BICJBG 

 
~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