Oracle OCP 1Z0 053 Q406(sql tuning advisor)

406.Which of these appropriately describes the results of a manual SQL Tuning Advisor task?
A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor, with before and after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it implemented the
recommended changes
D. All of the above
Answer: A

官方文件：https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE

17.2 SQL Tuning Advisor

The SQL Tuning Advisor takes one or more SQL statements as an input and invokes the Automatic Tuning Optimizer to perform SQL tuning on the statements. The output of the SQL Tuning Advisor is in the form of an advice or recommendations, along with a rationale for each recommendation and its expected benefit. The recommendation relates to collection of statistics on objects, creation of new indexes, restructuring of the SQL statement, or creation of a SQL profile. You can choose to accept the recommendation to complete the tuning of the SQL statements.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2074886/，如需轉載，請註明出處，否則將追究法律責任。