Oracle OCP 1Z0 053 Q118(Automatic SQL Tuning Task)
118.Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR top SQL identification
C. SQL statements that are part of the available SQL Tuning Set (STS) only
D. SQL statements that are available in the cursor cache and executed by a user other than SYS
Answer: B
http://docs.oracle.com/cd/E18283_01/server.112/e16638/sql_tune.htm
A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR top SQL identification
C. SQL statements that are part of the available SQL Tuning Set (STS) only
D. SQL statements that are available in the cursor cache and executed by a user other than SYS
Answer: B
http://docs.oracle.com/cd/E18283_01/server.112/e16638/sql_tune.htm
17.2.1 How Automatic SQL Tuning Works
Oracle Database automatically runs SQL Tuning Advisor on selected high-load SQL statements from the Automatic Workload Repository (AWR) that qualify as tuning candidates. This task, called Automatic SQL Tuning, runs in the default maintenance windows on a nightly basis. By default, automatic SQL tuning runs for at most one hour. You can customize attributes of the maintenance windows, including start and end time, frequency, and days of the week.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2075504/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
