Oracle
1Z0-054 · Question #192
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…
The correct answer is D. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set. See the full explanation below for the reasoning.
Question
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
Options
- ASet the OPTIMIZER_MODE parameter to ALL_ROWS for the database instance.
- BSet the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
- CSet the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE for the database
- DUse the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set
How the community answered
(54 responses)- A4% (2)
- B4% (2)
- C11% (6)
- D81% (44)
Community Discussion
No community discussion yet for this question.