Oracle
1Z0-054 · Question #29
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…
The correct answer is A. the EXPLAIN PLAN method. See the full explanation below for the reasoning.
Question
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?
Options
- Athe EXPLAIN PLAN method
- Bthe TEST EXECUTE method
- Cthe COMPARE PERFORMANCE method
- Dthe OPTIMIZER_USE_SQL_PLAN_BASELINE parameter set to TRUE
How the community answered
(19 responses)- A74% (14)
- B5% (1)
- C16% (3)
- D5% (1)
Community Discussion
No community discussion yet for this question.