Re: SPM again
- From: Job Miller <jobmiller@xxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Fri, 12 Mar 2010 05:30:50 -0800 (PST)
The "Automatic Plan Evolution of SQL Plan Management" inclusion in that list is
a mistake that I believe is being corrected. I'll validate that that entry is
being corrected in the docs.
sql plans in a baseline is not part of Auto SQL Tuning it is SPM.
Auto SQL Tuning is the automatic evaluation of sql statements for profiles, and
the creation of those profiles after .
--- On Fri, 3/12/10, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
> From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
> Subject: Re: SPM again
> To: jobmiller@xxxxxxxxx
> Cc: "BrandonAllen" <Brandon.Allen@xxxxxxxxxxx>, john.kanagaraj@xxxxxxxxx,
> "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> Date: Friday, March 12, 2010, 8:20 AM
> On Fri, Mar 12, 2010 at 12:59 PM, Job
> Miller <jobmiller@xxxxxxxxx>
> wrote:
> > 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.
>
> I wouldn't be so sure, the evolution definitely is
> tuning pack, and I believe that the existence of sql plans
> in a baseline is included in the "Automatic SQL
> Tuning" description, below quote from 11g docs.
>
>
>
>
> The Tuning Pack includes the following features:
>
> SQL Access Advisor
>
> SQL Tuning Advisor
>
> Automatic SQL Tuning
>
> SQL Tuning Sets
>
> Automatic Plan Evolution of SQL Plan
> Management
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
