Oracle
1Z0-054 · Question #46
1Z0-054 Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.