Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
Property | Description |
---|---|
Parameter type | Boolean |
Default value | true |
Modifiable | ALTER SESSION , ALTER SYSTEM |
Range of values | true | false |
Basic | No |
OPTIMIZER_USE_SQL_PLAN_BASELINES
enables or disables the use of SQL plan baselines stored in SQL Management Base. When enabled, the optimizer looks for a SQL plan baseline for the SQL statement being compiled. If one is found in SQL Management Base, then the optimizer will cost each of the baseline plans and pick one with the lowest cost.