Oracle
1Z0-054 · Question #26
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version that contains important SQL statements. You are not sure…
The correct answer is C. SQL Performance Analyzer (SPA). See the full explanation below for the reasoning.
Question
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version that contains important SQL statements. You are not sure about the elapsed time that the SQL statements will have in the new system due to the version change of the optimizer. Which tool provides a comparative report with respect to the elapsed time in both versions of the optimizer?
Options
- ASQL Access Advisor
- BSQL Tuning Advisor (STA)
- CSQL Performance Analyzer (SPA)
- DAutomatic Workload Repository (AWR) compare period report
How the community answered
(43 responses)- A7% (3)
- B19% (8)
- C70% (30)
- D5% (2)
Community Discussion
No community discussion yet for this question.