Disclaimer

Tuesday, 11 January 2022

OPTIMIZER_ADAPTIVE_PLANS parameter - 19c

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.


PropertyDescription

Parameter type

Boolean

Default value

true

Modifiable

ALTER SESSIONALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

true | false

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



No comments:

Post a Comment

Oracle Exadata

  Hardware Architecture:- Oracle Exadata Database Machine employs a modern scale-out architecture encompassing database compute, storage, ne...