Re: SPM again
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: jobmiller@xxxxxxxxx
- Date: Fri, 12 Mar 2010 17:37:42 +0100
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@xxxxxxxxx> 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
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
