Oracle OCP IZ0-053 Q46(SQL Tuning Advisor Limited)

46.What happens when you run the SQL Tuning Advisor with limited scope?
A. Access path analysis is not performed for SQL statements.
B. SQL structure analysis is not performed for SQL statements.
C. SQL Profile recommendations are not generated for SQL statements.
D. Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
Answer: C

從官方文件可以看出, limited對SQL Structure進行了分析，但是沒有產生SQL Profile

http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF94853


17.3.2 Tuning Options

SQL Tuning Advisor provides options to manage the scope and duration of a tuning task. You can set the scope of a tuning task either of the following:

• Limited

  In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

• Comprehensive

  In this case, SQL Tuning Advisor carries out all the analysis it performs under limited scope plus SQL Profiling. With the comprehensive option you can also specify a time limit for the tuning task, which by default is 30 minutes.

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