Oracle
1Z0-054 · Question #46
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…
The correct answer is A. Include the old plans in the SQL plan baseline. See the full explanation below for the reasoning.
Question
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. W hat would you suggest to avoid performance regression for these SQL statements?
Options
- AInclude the old plans in the SQL plan baseline.
- BUse DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE to evolve plans.
- CSet the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE.
- DIncrease the value for the OPTIMIZER_DYNAMIC_SAMPLING parameter.
How the community answered
(23 responses)- A78% (18)
- B13% (3)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.