1Z0-054 · Question #50
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…
The correct answer is C. creating a SQL Tuning Set by capturing the SQL workload on the production database and using. See the full explanation below for the reasoning.
Question
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?
Options
- Agathering all the SQL statements and using SQL Tuning Advisor on the test database for
- Bcapturing the workload on the production database, replaying it on the test machine, and
- Ccreating a SQL Tuning Set by capturing the SQL workload on the production database and using
- Dconfiguring AWR to capture the maximum number of SQL statements, transporting it to the test
How the community answered
(28 responses)- A14% (4)
- B7% (2)
- C75% (21)
- D4% (1)
Community Discussion
No community discussion yet for this question.