Which two tools would you recommend to achieve the obje…

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.)

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.)

A.
Database Replay

B.
SQL Tuning Advisor

C.
SQL Access Advisor

D.
Automatic Database Diagnostic Monitor (ADDM) compare periods report

E.
SQL Performance Analyzer

F.
Automatic Workload Repository (AWR) compare periods report



Leave a Reply 0

Your email address will not be published. Required fields are marked *