| Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
| Property | Description |
|---|---|
| Parameter type | Boolean |
| Default value | false |
| 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.