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

最新推荐文章于 2018-09-27 21:22:19 发布

EVISWANG

最新推荐文章于 2018-09-27 21:22:19 发布

阅读量516

点赞数

分类专栏： OCP 053

本文链接：https://blog.csdn.net/EVISWANG/article/details/50058545

版权

OCP 053 专栏收录该内容

86 篇文章 0 订阅

订阅专栏

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.