1Z0-054 Question #48: Real Exam Question with Answer & Explanation

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.