DomainKey-Signature:a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=ruFm5vVno0JITMtqPntyvXEEunVj/2k98LPXTBM0I9H2E5tvYaQyoXMOqWWxcx1yY97TqYLBmHjlEIJNVLiZHdWM5QCjlejimHfaCRwnpElY5C7NdXGPPvaLINxNKojpwx8+/6X9pMdfmY3z/HQozuYLDzEUSS8ztEXkbbc1KOM=;
References: <304F58144267C5439E733532ABC9A3A11403936A@USA0300MS02.na.xerox.net>
Message-ID: <1328217213.81844.YahooMailNeo@web36808.mail.mud.yahoo.com>
Date: Thu, 2 Feb 2012 13:13:33 -0800 (PST)
From: Antony Raj <ca_raj@yahoo.com>
Subject: Re: Enforcing plan via SQL plan baseline
To: "Amir.Hameed@xerox.com" <Amir.Hameed@xerox.com>,
  "oracle-l@freelists.org" <oracle-l@freelists.org>
In-Reply-To: <304F58144267C5439E733532ABC9A3A11403936A@USA0300MS02.na.xerox.net>
MIME-Version: 1.0
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: ca_raj@yahoo.com

Hi Amir,
 
You need to load the plan manually using DBMS_SPM package.Identify the SQLID of the plan that you need.
Manually loaded plans are automatically marked as accepted, so manual loading forces the evolving process.
 
Thanks
 

________________________________
From: "Hameed, Amir" <Amir.Hameed@xerox.com>
To: oracle-l@freelists.org 
Sent: Thursday, February 2, 2012 3:56 PM
Subject: Enforcing plan via SQL plan baseline

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