[go: nahoru, domu]

1.183 OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES

Property Description

Parameter type

Boolean

Default value

false

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

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

Scripting on this page enhances content navigation, but does not change the content in any way.