1.239 OPTIMIZER_USE_SQL_PLAN_BASELINES
OPTIMIZER_USE_SQL_PLAN_BASELINES enables or disables the use of SQL plan baselines stored in SQL Management Base.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
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.
See Also:
-
Oracle Database SQL Tuning Guide for information on enabling automatic initial plan capture
-
Oracle Database SQL Tuning Guide for information about configuring the capture and use of SQL plan baselines