RE: Enforcing plan via SQL plan baseline

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Thu, 2 Feb 2012 16:42:35 -0500
Message-ID: <304F58144267C5439E733532ABC9A3A114039403_at_USA0300MS02.na.xerox.net>

Yes...in the enabled column in dba_sql_plan_baselines shows a value of NO.

-----Original Message-----
From: andyklock_at_gmail.com [mailto:andyklock_at_gmail.com] On Behalf Of Andy Klock Sent: Thursday, February 02, 2012 4:42 PM To: Hameed, Amir
Cc: oracle-l
Subject: Re: Enforcing plan via SQL plan baseline

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:35 CST