30 April 2015
SQL Tuning Advisor - Switch off plan recommendations with parallelism
Symptoms
SQL Tuning Advisor recommends lots of plans with PX hints, claiming that parallelism puts the cost down. That might be a case, but in the case you don't want to use parallelism, there is a way to remove those recommendations.Solution
BEGINDBMS_AUTO_SQLTUNE.set_auto_tuning_task_parameter(
parameter => '_sqltune_control',
value => 1+2+4+8+32);
END;
/
To switch it back:
value => 1+2+4+8+10+32);
