What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?Once automatic SQL tuning begins, which by default runs for at most one hour during a maintenance window, the following steps are performed: … During the tuning process, all recommendation types are considered and reported, but only SQL profiles can be implemented automatically.References: https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE
Question:
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
Options:
statistics recommendations
SQL profile recommendations
SQL statement restructure recommendations
creation of materialized views to improve query performance
Correct Answer
The Correct Answer for this Question is
SQL profile recommendations
