Oracle
1Z0-064 · Question #2
You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test…
The correct answer is B. SQL Tuning Advisor E. SQL Performance Analyzer. See the full explanation below for the reasoning.
Question
You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:
- analyze and compare the overall database workload with concurrency
and transaction characteristics
- find SQL statements that might get regressed because of the upgrade
- analyze execution plans for SQL statements for which performance
might get regressed
- analyze the impact of new schema objects on database performance
Which two tools would you recommend to achieve the objective? (Choose two.)
Options
- ADatabase Replay
- BSQL Tuning Advisor
- CSQL Access Advisor
- DAutomatic Database Diagnostic Monitor (ADDM) compare periods report
- ESQL Performance Analyzer
- FAutomatic Workload Repository (AWR) compare periods report
How the community answered
(46 responses)- A2% (1)
- B74% (34)
- C9% (4)
- D2% (1)
- F13% (6)
Community Discussion
No community discussion yet for this question.