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

Understanding CSSD Heartbeat Mechanisms in Oracle RAC

  Understanding CSSD Heartbeat Mechanisms in Oracle RAC The Cluster Services Synchronization Daemon (CSSD) is a critical process in Oracle...