ABD
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/sql-tuning-advisor.html#GUID-CB843CA1-6160-4918-BC71-86E36775EF15
AB - If these statistics are stale or missing, then the optimizer can generate suboptimal plans. Automatic Tuning Optimizer checks for missing or stale statistics, and recommends gathering fresh statistics if needed.
D - During structural analysis, Automatic Tuning Optimizer tries to identify syntactic, semantic, or design problems that can lead to suboptimal performance. The goal is to identify poorly written SQL statements and to advise you how to restructure them.
not c - only recommends syntactic changes
D should be correct according to: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/sql-tuning-advisor.html#GUID-982EB0FC-AADD-4741-B0AA-79005C3AF657
A B F:
"F" because the question is related to "SQL Tuning Advisor" not to the "Automatic" one. Therefore the following applies:
"SQL profiles are created when a DBA invokes SQL Tuning Advisor." (https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/managing-sql-profiles.html#GUID-1AC3C45E-331A-4016-8FE8-7FEFFD8D7220)
"D" is false because it can recommend syntactic, not semantic, restructuring
Not F
"for improving performance of high-load SQL statements" NOT "for each poorly performing SQL statement"
https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/sql-tuning-advisor.html#GUID-73AB38C1-A7F6-401E-9010-B4476E173673
SQL Tuning Advisor is a mechanism for resolving problems related to suboptimally performing SQL statements.
Use SQL Tuning Advisor to obtain recommendations for improving performance of high-load SQL statements, and prevent regressions by only executing optimal plans.
i change to ABD! it will not create a profile for EACH poorly, e.g. one time queries.
further: µµThe Automatic Tuning Optimizer identifies common problems with structure of SQL statements than can lead to poor performance. These could be syntactic, semantic, or design problems with the statement.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ald85
Highly Voted 4 years, 7 months agomarkwu01
4 years, 6 months agorodriguesJC
3 years, 3 months agofreemun05
2 years, 10 months agodancymonkey
1 year agoveginha
Highly Voted 4 years, 7 months agoYennism
Most Recent 1 year, 1 month agoKuraudio
1 year agoguretto
1 year, 1 month agoauwia
7 months, 3 weeks ago_gio_
1 year, 9 months agoflaviogcmelo
2 years, 4 months agoegore0496
3 years agorashedptdba
3 years, 4 months agoNeil107
3 years, 6 months agoManojx
3 years, 8 months agoPortlandFighters
3 years, 4 months agotest202102
4 years agojanw
4 years, 5 months agojanw
4 years, 5 months agocerebro2000x
4 years, 6 months agomarcinb32
4 years, 7 months agoklever35
4 years, 7 months ago