Database Reference
ContentsOpens a new window
Opens a new window
Page 205 of 2693

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

Previous PageOpens a new window
Page 205 of 2693
Next PageOpens a new window