What would you do to allow the Automatic SQL Tuning implement the SQL profiles automatically?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

pre-11gR2, DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETER
11.2.0.2 onward, DBMS_AUTO_SQLTUNE.SET_TUNING_PARAMETER

D is correct