Re: SPM again
- From: John Kanagaraj <john.kanagaraj@xxxxxxxxx>
- To: sacrophyte@xxxxxxxxx, jobmiller@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 11 Mar 2010 14:50:36 -0800
Hi Job and Charles,
I have not used this in Production yet, but I do see another use for
SPM. My problem is this: AWR is stored (by default) for 7 days - and
we loose older SQL ID/Plan Hash information (unless you custom extract
it). I would like to turn on OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES in
the Dev/Test/Stage environments, capture Plans and use SPM to store
this longer term without the overhead of either creating my own custom
copy of AWR or (worse!) retaining AWR for substantially longer
periods.
Auto evolve plan baselines?? (Hmmmm - I don't think I am that mad
yet!) Seriously, you are going to allow the optimizer to pick the
lower cost plan when you *know* that the lower cost plan (as
calculated) is sometimes not the "right thing" to do?
Having said that, if I am using Stored Outlines, then I would have to
migrate to SPM to remain supported.
Plan stability? What is that??! (Just kidding).
John
>> 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?
>>
On Thu, Mar 11, 2010 at 12:24 PM, Charles Schultz <sacrophyte@xxxxxxxxx> wrote:
> I know I am very interesting in getting my hands on it. However we have not
> explored 11g that much, yet. I would be curious to hear from those that have
> used SPM in production, or at least those that are testing 11g and SPM as
> they prepare for production. I have read a number of whitepapers (by both
> Oracle and non-Oracle employees) and am thankful for them, but have not
> found any stories from Real Life(tm) yet.
>
> On Thu, Mar 11, 2010 at 13:30, 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.
>>
>> maybe I should create a survey...
>>
>> Job
>>
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
>
>
> --
> Charles Schultz
>
--
John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
//www.freelists.org/webpage/oracle-l
Other related posts:
