Re: Survey: 11g plan management (DBMS_SPM)

From: Marcin Przepiorowski <>
Date: Mon, 20 Jun 2011 13:59:51 +0100
Message-ID: <>

2011/6/20 <>:
> 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.


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.


Marcin Przepiorowski
Received on Mon Jun 20 2011 - 07:59:51 CDT

Original text of this message