Performance divergence indicated in the Workload Replay report is most likely due to what?
A.
DML and SQL statement results that do not match between the capture and replay
systems
B.
When errors that occur in the capture system don’t occur in the replay system
C.
Top SQL statements
D.
Infrastructure or system-configuration differences
E.
Time-of-day differences between capture and replay systems
Performance divergence may result when new algorithms are introduced in the replay system that affect the overall performance of the database. For example, if the workload is replayed on a newer version of Oracle Database, a new algorithm may cause specific requests to run faster, and the divergence will appear as a faster execution. In this case, this is a desirable divergence.
D
This question was in a book called All-in-One exam guide for 051, 52, 53 (I think). Here is the answer.
20. D. Option A is incorrect; DML and SQL results drive data divergence. Option B is incorrect because error divergence, not performance divergence, happens when errors that occur in the capture system don’t occur in the replay system. Top SQL statements should behave the same in the capture and replay systems, unless there is a data-divergence issue, so C is incorrect. E is incorrect because the time of day should have no impact on differences between the capture and replay systems. It is possible that other workloads running on the capture and replay systems that have a time-of-day trend might impact performance, but that is an extraneous variable, not a cause.