Re: SPM again
Date: Fri, 12 Mar 2010 04:59:37 -0800 (PST)
There are no licensing implications of SPM. It is included with EE. The job that evolves plans in the nightly maintenance window is also included.
Using the tuning pack to create a SQL profile and add the associated plan from the execution of that statement with the profile obviously requires tuning and diagnostics.
- On Thu, 3/11/10, John Kanagaraj <john.kanagaraj_at_gmail.com> wrote:
> From: John Kanagaraj <john.kanagaraj_at_gmail.com>
> Subject: Re: SPM again
> To: "Allen, Brandon" <Brandon.Allen_at_oneneck.com>
> Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Date: Thursday, March 11, 2010, 6:37 PM
> Hi Brandon,
> > Why not just create a few preserved snapshots at your
> desired interval to retain older plans in AWR?
> The problem with this approach is this: One would need to
> retain all
> of AWR data for *just* the SQL and SQL plans. The other is
> this: A
> Dev/Test would run over a long period, with SQL plans
> during this period. We would not be able to get all the
> snapshots and
> preserve them....
> SPM, IMHO, provides an easy way to do this provided you are
> to pay for the license. Don't get me wrong: I am not
> advocating using
> SPM right away, and we still need to work through all the
> bugs and
> "features" :)
> John Kanagaraj <><
> http://jkanagaraj.wordpress.com (Sorry - not an Oracle
> ** The opinions and facts contained in this message are
> entirely mine
> and do not reflect those of my employer or customers **