You are a DBA in ABC Corp. You are working on a DSS system.. The applications directly
connect to the database to perform transactions. The application users also perform direct loads.
The company wants to upgrade from Oracle Database 10g version 10.2.0.1 to Oracle Database
11g. You want to test the performance of the SQL statements in the new environment before
upgrading the production database. To accomplish this, you set up the test database with Oracle
Database 11g, with the same data and schemas as in production.
What would you recommend to accomplish the task?
A.
gathering all the SQL statements and using SQL Tuning Advisor on the test database for
performance analysis
B.
capturing the workload on the production database, replaying it on the test machine, and
comparing the performance
C.
creating a SQL Tuning Set by capturing the SQL workload on the production database and
using SQL Performance Analyzer for performance analysis
D.
configuring AWR to capture the maximum number of SQL statements, transporting it to the test
system, and using SQL Access Advisor for performance analysis
create STS and use SPA to analyze
So C is correct