OCP-1Z0-053-V13.02-233题
来源:互联网 发布:java集合用大括号 编辑:程序博客网 时间:2024/06/05 22:47
233.Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported
SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE
parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression
for a few SQL statements. What would you do with these SQL statements?
A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
B. Capture the plans from the previous version using STS and then load them into the stored outline.
C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
Answer: C
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/16369811
- OCP-1Z0-053-V13.02-233题
- OCP-1Z0-053-V13.02-1题
- OCP-1Z0-053-V13.02-682题
- OCP-1Z0-053-V13.02-687题
- OCP-1Z0-053-V13.02-692题
- OCP-1Z0-053-V13.02-696题
- OCP-1Z0-053-V13.02-711题
- OCP-1Z0-053-V13.02-710题
- OCP-1Z0-053-V13.02-709题
- OCP-1Z0-053-V13.02-708题
- OCP-1Z0-053-V13.02-706题
- OCP-1Z0-053-V13.02-490题
- OCP-1Z0-053-V13.02-24题
- OCP-1Z0-053-V13.02-36题
- OCP-1Z0-053-V13.02-43题
- OCP-1Z0-053-V13.02-45题
- OCP-1Z0-053-V13.02-60题
- OCP-1Z0-053-V13.02-651题
- 使用DDK提供的build进行编译驱动一点总结
- short s1 = 1; s1 = s1 + 1;有什么错? short s1 = 1; s1 += 1;有什么错?
- MT6572 的UART串口寄存器DATASHEET
- hibernate3与实体类型无关的映射方式---动态模型(Dynamic Model)
- Cocos2d-x坐标研究
- OCP-1Z0-053-V13.02-233题
- 横线登记式明细分类账
- linux gcc 静态编译和动态编译
- linux 下安装和卸载oracle
- 【opencv】 特征点检测 sift和surf
- nginx配置文件详解
- Exception Handling
- ibatis使用proxool连接池
- bootstrap中的typeahead