opt_param
sets the value of a limited set of init parameters (which are all related to the optimizer) for the duration of the SQL statement. The syntax is: /*+ opt_param(<parameter_name> [,] <parameter_value>) */
/*+ opt_param('_optimizer_adaptive_plans', 'false') */
or /*+ opt_param('_parallel_syspls_obey_force', 'false') */
. optimizer_features_enable
has a corresponding hint with the same name. opt_estimate
.