本文探讨了在默认配置下，数据库实例中SQL调优顾问运行作为自动维护任务的一部分时，哪种类型的建议会自动实施。解释了为什么SQL Profile建议是唯一能被自动实施的类型。
QUESTION 102
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation
is automatically implemented after the SQL Tuning Adv isor is run as part of the automatic maintenance task?
A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations
Answer: B
同38题：http://blog.youkuaiyun.com/rlhua/article/details/14089909
Explanation/Reference:
Section: Managing Database Performance & Tuning
http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDIBFGA
During the tuning process, all recommendation typesare considered and reported, but only SQL profiles can
be implemented automatically.
扫一扫
441
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
