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?
Exhibit:

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 0

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