Identify the correct steps required to perform the test.

Your company wants to migrate a single instance Oracle 11g Release 1 database to a RAC
environment. The database supports middle-tier applications using connection pooling for
connecting to database.
Being a part of the performance management team, you want to test the performance of the SQL
statements and the peak workload of the applications in the new environment before upgrading
the production system.
Given below are some of the steps in random order to accomplish the task:
1) Capture the real workload on the existing system.
2) Create a SQL Tuning Set (STS) for the statements executed by the application.
3) Transport STS on the test environment and use SQL Tuning Advisor to compare the before and
after performance.
4) Replay the workload on the test environment.
5) Analyze the divergence after replay.
6) Use Automatic Workload Repository (AWR) to capture the information for top SQL on the
existing system.
7) Transport STS on the test environment and use SQL Performance Analyzer to compare the
before and after performance.
Identify the correct steps required to perform the test.

A.
2 and 3 only

B.
6 and 7 only

C.
1, 4, and 5 only

D.
2, 3, and 5 only

E.
2, 3, 4, and 5 only