Your database supports an online transaction processing (OLTP) application. The
application is undergoing some major schema changes, such as addition of new indexes
and materialized views. You want to check the impact of these changes on workload
performance. What should you use to achieve this?
A.
Database replay
B.
SQL Tuning Advisor
C.
SQL Access Advisor
D.
SQL Performance Analyzer
E.
Automatic Workload Repository compare reports
A
A is Wrong
D is Correct
It seems like ‘A’ Database replay is the correct answer.
bne says:
February 15, 2016 at 6:43 pm
Answer A: in Exam only 4 answers (without SQL Performance Analyser).
I passed today the exam with 88% and 93%
A is the right answer
E – Automatic Workload Repository compare reports
The question asks “You want to check the impact of these changes on workload
performance”
The key is needing to know the changes on Workload Performance. The AWR compare reports does this.
A
Well, A and E.
A (Database replay) to reproduce production workload on a new (changed) system and E (SQL Performance Analyzer) to analyse impact of schema changes on SQL statements i.e. which one degraded in performance, which not, etc.
The best answer is:
D.
SQL Performance Analyzer
And this is just a major schema change. So why use database replay? it is not appropriate for this scenario.
1 SQL Performance Analyzer
SQL Performance Analyzer enables you to assess the performance impact of any system change resulting in changes to SQL execution plans and performance characteristics. Examples of common system changes for which you can use SQL Performance Analyzer include:
Database upgrade
Configuration changes to the operating system, hardware, or database
Database initialization parameter changes
Schema changes, for example, adding new indexes or materialized views
Gathering optimizer statistics
Validating SQL tuning actions, for example, creating SQL profiles or implementing partitioning
agree
the source: https://docs.oracle.com/cd/B28359_01/server.111/e12159/spa.htm