Re: SQL Profiles and Performance

From: Kerry Osborne <kerry.osborne_at_enkitec.com>
Date: Mon, 16 Apr 2012 14:20:51 -0500
Message-Id: <D4647813-806F-41E8-BD12-1C3B39C9D9F8_at_enkitec.com>



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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 16 2012 - 14:20:51 CDT

Original text of this message