试题详情
- 单项选择题 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.
- C
关注下方微信公众号,在线模考后查看
热门试题
- View the E
- You want to perform
- 如何将变量v_row定义为emp表的记录
- Which statemen
- You want
- Examine the structu
- Click the
- The WF_PARAMETER_LIS
- In the p
- You executed&e
- 在Oracle中,下面哪条语句当COMM
- What are two benefit
- You have a very larg
- 为了减少表中的链接记录和迁移记录,应当增
- You issued&ensp
- The NLS_SORT
- The database&e
- 在逻辑备份表expdp命令中,哪个参数是
- 当在SQL*Plus中需要以DBA连接到
- DRAGDROPClicktheTask