Re: SQL Profiles and Performance
- From: Kerry Osborne <kerry.osborne@xxxxxxxxxxx>
- To: "Tefft, Michael J" <Michael.J.Tefft@xxxxxxxxxx>
- Date: Mon, 16 Apr 2012 14:20:51 -0500
Yes - my bad. I meant capture=yes not use=yes in my previous email.
Kerry Osborne
Enkitec
blog: kerryosborne.oracle-guy.com
On Apr 16, 2012, at 11:38 AM, Tefft, Michael J wrote:
> The default value for OPTIMIZER_USE_SQL_PLAN_BASELINES is TRUE.
> The default value for OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES is FALSE.
>
> There is little harm in using the default settings. If you have no baselines,
> then USE has no real effect. If your application vendor provides baselines
> with their installation, your database can make use of them.
>
> The caution applies to changing CAPTURE to YES.
>
> Mike
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
