What should you use to achieve this?

http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_spia.htm#TDPPT202

Any global changes made on the system to test the performance effect may also affect other users of the system. For smaller changes, such as adding or dropping an index, the effect on other users may be acceptable. However, for systemwide changes, such as a database upgrade, using a production system is not recommended and should be considered only if a test system is unavailable. If a separate test system is available, then running SQL Performance Analyzer on the test system enables you to test the effects of the changes without affecting the production system.

To ensure that SQL Performance Analyzer can accurately analyze the SQL performance impact, the test system should be as similar to the production system as possible. For these reasons, running SQL Performance Analyzer on a test system is recommended and is the methodology described here. If you choose to run SQL Performance Analyzer on the production system, then substitute the production system for the test system where applicable.

There is no option D SQL Performance Analyser in exam. So I have choose E.

(A) – DB replay not OK because schema changed (new indexes, mvievs).

So the answer is E – AWR compare periods, which allows to compire performance before and after schema changes.

A

In Oracle Database 11g,the new Database Replay tool works like a DVR inside the database. Using a unique approach, it faithfully captures all database activity beneath the level of SQL in a binary format and then replays it either in the same database or in a different one (which is exactly what you would want to do prior to making a database change). You can also customize the capture process to include certain types of activity, or perhaps exclude some.
Database Replay delivers half of what Oracle calls Oracle Database 11g’s Real Application Testing option; the other half is provided by another tool, SQL Performance Analyzer. The main difference between these two tools is the scope involved: whereas Database Replay applies to the capture and replay of all (subject to some filtering) activities in a database, SQL Performance Analyzer allows you to capture specific SQL statements and replay them. (You can’t see or access specific SQLs captured in Database Replay, while in SQL Performance Analyzer you can.) The latter offers a significant advantage for SQL tuning because you can tweak the SQL statement issued by an application and assess its impact.

So B,C,D are ruled out.

AWR Compare period report gives the reason for degradation between 2 periods. Hence this cannot be answer to this question.
Hence I believe the correct answer is A (Database Replay). This is an OLTP app, and you want to see the impact of schema changes, index additions, etc., on the workload. Hence I am sure the answer is A.

my opinion is E

https://docs.oracle.com/cd/B28359_01/server.111/e12253/dbr_intro.htm#CHDJEBAC

you use DB replay to run but AWR to analyze the results

there is no test system, so A is discarted, and sql performance analyze is over “SQL” workload, not overall workload so , does not check, so D is discarted, same B and C, so E is the correct

Database Replay
. Capture the workload for a database and replays it exactly on a test database
. Test your upgrade because you can capture actual workload in a production system, and then reply that workload in a test environment that includes the new OS and the new database objects.
Note. You need a backup of the original database as it looked before the capture started, so that database can be restored in your test environment.

SQL Performance Analyzer(SPA) can analyze the SQL performance impact of SQL tuning and other system changes. SPA is often used in conjunction with database replay, and allows you to execute test SQL statements to test system throughput.

A

I think D is the correct answer

You can use the SQL Performance Analyzer to analyze the impact on SQL performance of any type of system changes, including:

Database upgrade
Database consolidation testing for pluggable databases (PDBs) and manual schema consolidation
Configuration changes to the operating system or hardware
Schema changes —*****–
Changes to database initialization parameters
Refreshing optimizer statistics
Validating SQL tuning actions

Sites of interest we’ve a link to

usually posts some really intriguing stuff like this. If you are new to this site

always a major fan of linking to bloggers that I like but dont get lots of link like from

Wonderful story, reckoned we could combine a couple of unrelated data, nonetheless seriously really worth taking a appear, whoa did one particular study about Mid East has got much more problerms at the same time

Wonderful story, reckoned we could combine a couple of unrelated information, nonetheless definitely worth taking a look, whoa did a single understand about Mid East has got additional problerms too

the time to read or go to the content or web sites we have linked to beneath the

The key words here are:
– undergoing in “The application is undergoing some major schema changes”. So we are not in prod yet.
– “check the impact”
So the answer should be Database Replay : A

below you will discover the link to some web pages that we consider it is best to visit

Every after inside a while we select blogs that we study. Listed below would be the latest websites that we pick

check below, are some entirely unrelated internet websites to ours, nonetheless, they are most trustworthy sources that we use

usually posts some very interesting stuff like this. If youre new to this site

that could be the end of this post. Right here you will obtain some sites that we think you will enjoy, just click the hyperlinks over

we prefer to honor many other world-wide-web web-sites around the net, even when they arent linked to us, by linking to them. Beneath are some webpages worth checking out

one of our visitors not too long ago proposed the following website

the time to read or visit the material or web-sites we’ve linked to beneath the

Here are some of the web-sites we advise for our visitors

D

Schema change

Changing a schema, such as altering indexes or creating new ones, almost inevitably affects SQL performance. SQL Performance Analyzer enables you to determine the effect on SQL performance when making a schema change.