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 = Run the command as sysdba.

 alter system set "_optimizer_nlj_hj_adaptive_join"= FALSE scope=both sid='*'; alter system set "_optimizer_strans_adaptive_pruning" = FALSE scope=both sid='*';

 alter system set "_px_adaptive_dist_method" = OFF scope=both sid='*';

 alter system set "_sql_plan_directive_mgmt_control" = 0 scope=both sid='*';

 alter system set "_optimizer_dsdir_usage_control" = 0 scope=both sid='*';

 alter system set "_optimizer_use_feedback" = FALSE scope=both sid='*';

 alter system set "_optimizer_gather_feedback" = FALSE scope=both sid='*';

 alter system set "_optimizer_performance_feedback" = OFF scope=both sid='*';

 restart the db.