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 optimizer_features_enable`[corresponding hint with the same name]. opt_estimate.