View the Exhibit and examine the result of Automatic SQL Tuning for a period. None of the
recommended SQL profiles are implemented. What would you do to allow the Automatic SQL
Tuning implement the SQL profiles automatically?
A.
Set the OPTIMIZER_MODE parameter to ALL_ROWS for the database instance.
B.
Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
C.
Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE for the
database instance.
D.
Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set
ACCEPT_SQL_PROFILES to TRUE.
pre-11gR2, DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETER
11.2.0.2 onward, DBMS_AUTO_SQLTUNE.SET_TUNING_PARAMETER
D is correct