多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题