Your system is upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL
Tuning Sets (STS) from the previous version. After running the SQL Performance Analyzer for
optimizer version change, you observe performance regression for a few SQL statements. What
would you suggest to avoid performance regression for these SQL statements?
A.
Include the old plans in the SQL plan baseline.
B.
Use DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE to evolve plans.
C.
Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE.
D.
Increase the value for the OPTIMIZER_DYNAMIC_SAMPLING parameter.
including old plans in SQL Plan Baselines. so the new plan will need to be verified before accepted and used. If new plans are not as good as old plans, they are not used.
A is correct