What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

Statistics recommendations from the SQL Tuning Advisor are not auto-implemented because gathering new optimizer statistics can alter execution plans for many other queries beyond the one being tuned, requiring DBA review.

SQL profiles are the only recommendation type that the automated SQL Tuning Advisor task is permitted to implement automatically, because a SQL profile stores auxiliary statistical corrections alongside the statement without altering the SQL text itself, making it a safe, non-invasive change. Oracle's automated task infrastructure calls DBMS_SQLTUNE.ACCEPT_SQL_PROFILE on qualifying recommendations where the profile produces a measurable performance improvement, typically three times better than the original plan.

SQL statement restructure recommendations involve rewriting the actual SQL text, which requires developer or DBA involvement and cannot be applied automatically by the maintenance task.

Recommendations to create materialized views for query performance come from the SQL Access Advisor, not the SQL Tuning Advisor, and always require explicit DBA approval and manual creation.