OCP 1Z0 053 46
来源:互联网 发布:明教成女脸型数据 编辑:程序博客网 时间:2024/06/04 18:20
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: B
http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm#PFGRF94853
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: B
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.
0 0
- OCP 1Z0 053 46
- OCP 1Z0 053 1
- OCP 1Z0 053 2
- OCP 1Z0 053 3
- OCP 1Z0 053 4
- OCP 1Z0 053 5
- OCP 1Z0 053 6
- OCP 1Z0 053 7
- OCP 1Z0 053 8
- OCP 1Z0 053 9
- OCP 1Z0 053 10
- OCP 1Z0 053 11
- OCP 1Z0 053 12
- OCP 1Z0 053 13
- OCP 1Z0 053 14
- OCP 1Z0 053 15
- OCP 1Z0 053 16
- OCP 1Z0 053 17
- java中常被忽略的几个问题
- 自旋锁、排队自旋锁、MCS锁、CLH锁
- 如何组织一个高效的开发团队?
- 关于Java的装箱小测试
- 关于ListView的HeaderView
- OCP 1Z0 053 46
- 远程登入mysql
- Tomcat访问日志详细配置
- 互联网时代商业模式的创新探讨
- JDK + ECLIPSE + TOMCAT + AXIS2 开发环境的搭建
- (二)SSO之CAS框架单点退出,自定义退出界面.
- 定位CPU高的方法
- Android LayoutParams的用法
- Http长连接200万尝试及调优