---

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.

---

出自：Oracle认证

显示答案