Re: Enforcing plan via SQL plan baseline

From: Andy Klock <andy_at_oracledepot.com>
Date: Thu, 2 Feb 2012 16:42:17 -0500
Message-ID: <CADo_RaNb3uFMkjg_UD0eOeXC4z9_+jNb8_1XiomEFaNag_3Rrw_at_mail.gmail.com>



That's strange. Can you verify that it was actually disabled?
SELECT sql_handle, plan_name, enabled, accepted
FROM   dba_sql_plan_baselines
WHERE  sql_handle = '&1'

On Thu, Feb 2, 2012 at 4:30 PM, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> Thanks...that did not work either.
>
> -----Original Message-----
> From: andyklock_at_gmail.com [mailto:andyklock_at_gmail.com] On Behalf Of Andy
> Klock
> Sent: Thursday, February 02, 2012 4:28 PM
> To: Hameed, Amir
> Subject: Re: Enforcing plan via SQL plan baseline
>
> Disable the plan(s) that you don't want to be used:
>
> DBMS_SPM.alter_sql_plan_baseline
> attribute_name  => 'enabled',
> attribute_value => 'NO');
>

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

Original text of this message