You upgraded database from the Oracle Database 10g to Oracle Database 11g. To test the performance SQL on the upgraded database. You want to build the before-change performance data by using SQL Performance Analyzer .Which method would allow the task to execute quickly?
A. the EXPLAIN PLAN method
B. the TEST EXECUTE method
C. the COMPARE PERFORMANCE method
D. the OPTIMIZER_USE_SQL_PLAN_BASELINE parameter set to TRUE
Answer:A
You upgraded database from the Oracle Database 10g to Oracle Database 11g. To test the performance SQL on the upgraded database. You want to build the before-change performance data by using SQL Performance Analyzer .Which method would allow the task to execute quickly?
A. the EXPLAIN PLAN method B. the TEST EXECUTE method C. the COMPARE PERFORMANCE method D. the OPTIMIZER_USE_SQL_PLAN_BASELINE parameter set to TRUE