Re: Expensive SQL
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 2 Sep 2011 19:16:57 +0000 (UTC)
Message-ID: <pan.2011.09.02.19.16.57_at_gmail.com>
On Tue, 23 Aug 2011 08:07:54 -0700, dombrooks wrote:
Date: Fri, 2 Sep 2011 19:16:57 +0000 (UTC)
Message-ID: <pan.2011.09.02.19.16.57_at_gmail.com>
On Tue, 23 Aug 2011 08:07:54 -0700, dombrooks wrote:
> It's a bug - # 11719151
>
> See http://orastory.wordpress.com/2011/03/01/sql-baseline-capture-bu/
>
> Patch.
>
> In the interim, you can disable baseline usage and/or delete existing
> baselines (dba_sql_plan_baselines & dbms_spm).
Just to let you know, once I cleaned up the existing baselines, everything returned back to normal. This is a big bug.
-- http://mgogala.byethost5.comReceived on Fri Sep 02 2011 - 14:16:57 CDT