OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES


Property Description

Parameter type

Boolean

Default value

true

Modifiable

ALTER SESSION, ALTER SYSTEM

Range of values

true | false

Basic

No


OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES enables or disables the automatic recognition of repeatable SQL statements, as well as the generation of SQL plan baselines for such statements.

See Also:

Oracle Database SQL Tuning Guide for more information about the optimizer