1.224 OPTIMIZER_ADAPTIVE_PLANS
OPTIMIZER_ADAPTIVE_PLANS controls adaptive plans. Adaptive plans are execution plans built with alternative choices that are decided at run time based on statistics collected as the query executes.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
The same value must be set on all instances |
Setting this parameter to false disables the following adaptive features:
-
Nested loop join/hash join selection
-
Star transformation bitmap pruning
-
Adaptive parallel distribution method
See Also:
Oracle Database SQL Tuning Guide for information about adaptive plans