95 The SQL Tuning Advisor configuration has default settings in your database instance. Which recomm

最新推荐文章于 2025-09-01 09:13:10 发布

原创最新推荐文章于 2025-09-01 09:13:10 发布 · 607 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

OCP 053

当前文章被收录于：

OCP 053

86 篇文章 0 人学习

订阅专栏查看详情

当前文章被以下社区和专栏收录：

本文探讨了数据库中SQL调优顾问配置的默认设置下，哪些类型的推荐会在作为自动维护任务一部分运行SQL调优顾问时被自动实施。文中指出，在调优过程中，所有类型的建议都会被考虑并报告，但只有SQL配置文件可以被自动实施。

95
The SQL Tuning Advisor configuration has default settings in your database instance. Which
recommendation is automatically implemented after the SQL Tuning Advisor 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

Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDIBFGA
During the tuning process, all recommendation types are considered and reported, but only SQL profiles
can be implemented automatically.