Prerequisite Name = Check if all adaptive features parameters are unset
Prerequisite Detailed Name = Check if all adaptive features parameters are unset
Prerequisite Status = fail
Prerequisite Recommendation = All adaptive features parameters should be unset for improved SQL performance
Prerequisite Detailed Recommendation = If you have set below parameters on 18.x, 19.x etc database, you need to reset them by running below commands as sysdba:
alter system reset “_optimizer_nlj_hj_adaptive_join” scope=both sid=’’; alter system reset “_optimizer_strans_adaptive_pruning” scope=both sid=’’;
alter system reset “_px_adaptive_dist_method” scope=both sid=’’;
alter system reset “_sql_plan_directive_mgmt_control” scope=both sid=’’;
alter system reset “_optimizer_dsdir_usage_control” scope=both sid=’’;
alter system reset “_optimizer_use_feedback” scope=both sid=’’;
alter system reset “_optimizer_gather_feedback” scope=both sid=’’;
alter system reset “_optimizer_performance_feedback” scope=both sid=’’;