Re: Expensive SQL
From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 24 Aug 2011 15:41:49 +0000 (UTC)
Message-ID: <pan.2011.08.24.15.41.47_at_email.here.invalid>
On Tue, 23 Aug 2011 16:20:52 +0000, Mladen Gogala wrote:
Date: Wed, 24 Aug 2011 15:41:49 +0000 (UTC)
Message-ID: <pan.2011.08.24.15.41.47_at_email.here.invalid>
On Tue, 23 Aug 2011 16:20:52 +0000, Mladen Gogala wrote:
> SQL> declare
> 2 cursor spm is select sql_handle from dba_sql_plan_baselines; 3
> stat number;
> 4 begin
> 5 for c in spm loop
> 6 stat:=dbms_spm.drop_sql_plan_baseline(c.sql_handle,null); 7 end
> loop;
> 8 commit;
> 9 end;
> 10 /
>
> Hopefully, that will clean things up.
This is running exceptionally slowly.
-- http://mgogala.byethost5.comReceived on Wed Aug 24 2011 - 10:41:49 CDT