Re: SPM again
Date: Fri, 12 Mar 2010 17:37:42 +0100
Message-ID: <6e9345581003120837k1df9e569q94a31c5545fe9a5_at_mail.gmail.com>
I have not really have a look at this feature although I have migrated a few database to 11gR1.
Since I have not used it throughly I dont think I am in position to state any points however considering those applications which does not use bind variables wouldnt SPM be a killer for them? Since there are so many parses and so many plan evaluations!
Thanks
On Thu, Mar 11, 2010 at 8:30 PM, Job Miller <jobmiller_at_yahoo.com> wrote:
> I asked a few weeks ago and got no takers.
>
> Has anyone turned on SQL Plan Management in an 11g DB environment?
> For all the focus around here on the optimizer, it seems that SPM would
> have been something DBAs were quite interested in leveraging, assuming they
> read the New Features docs and were aware of it.
>
> If so, what have you seen from it?
>
> Are you letting it auto evolve plan baselines?
>
> Are you watching it like a hawk?
>
> Or are you living in the stored outline world for plan stability still?
>
> Or was plan stability never an issue you observed?
>
> maybe I should create a survey...
>
> Job
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 12 2010 - 10:37:42 CST