Re: Survey: 11g plan management (DBMS_SPM)
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Mon, 20 Jun 2011 13:59:51 +0100
Message-ID: <BANLkTi=zSDBf6S5=vSAXzOt-OHdFWBe3YQ_at_mail.gmail.com>
2011/6/20 <Laimutis.Nedzinskas_at_seb.lt>:
> Thank you all.
>
> But did anyone try to use SPM on a global scale? To freeze a stable
> production application ? Sounds scarry to me but how to know w/o trying ?
> I can guess some issue like slower sql parsing, latching/"mutexing", etc
> with a large number of SQL baselines. Would be interesting to know load on
> CPU either.
>
Date: Mon, 20 Jun 2011 13:59:51 +0100
Message-ID: <BANLkTi=zSDBf6S5=vSAXzOt-OHdFWBe3YQ_at_mail.gmail.com>
2011/6/20 <Laimutis.Nedzinskas_at_seb.lt>:
> Thank you all.
>
> But did anyone try to use SPM on a global scale? To freeze a stable
> production application ? Sounds scarry to me but how to know w/o trying ?
> I can guess some issue like slower sql parsing, latching/"mutexing", etc
> with a large number of SQL baselines. Would be interesting to know load on
> CPU either.
>
Hi,
I'm using it to freeze plans for whole application - and it is running quite well even with 300 - 400 plans in dba_sql_plan_baseline. Of course there are issues with plans and I'm going to blog about that soon - there is a few gotcha but if you are aware it is nice to use.
regards,
-- Marcin Przepiorowski http://oracleprof.blogspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 20 2011 - 07:59:51 CDT