Search notes:

Oracle: Init parameter OPTIMIZER_ADAPTIVE_PLANS

optimizer_adaptive_plans controls all types of adaptive plans.
Setting it to false disables the following adaptive features:

See also

init parameters

Index