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
Explanation:
While an AWR report shows AWR data between two snapshots (or two points in
time), the AWR Compare Periods report shows the difference between two periods (or two AWR
reports with a total of four snapshots). Using the AWR Compare Periods report helps you to
identify detailed performance attributes and configuration settings that differ between two time
periods.
Reference: Resolving Performance Degradation Over Time
And what about A??
I would say C
It is A, since RAT tool’s “database replay” runs the whole workload after making the underline changes to DB or DB objects and it measure the change in workload before and after the changes.
C
The correct is “D”- SQL Performance Analyzer
OPTION D
https://oracle-base.com/articles/11g/sql-performance-analyzer-11gr1
https://docs.oracle.com/cd/B28359_01/server.111/e12253/dbr_intro.htm
“You can use Database Replay to capture a workload on the production system and replay it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload. This enables you to test the effects of a system change without affecting the production system.”
Answ A
Please remember 12c exam is based on 12.1.0.1 some people get confused because of changes in new version
D
SQL Performance Analyzer in Oracle Database 11g Release 1
The concept of SQL tuning sets, along with the DBMS_SQLTUNE package to manipulate them, was introduced in Oracle 10g as part of the Automatic SQL Tuning functionality. Oracle 11g makes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change. The database change can be as major or minor as you like, such as:
Database, operating system, or hardware upgrades.
Database, operating system, or hardware configuration changes.
Database initialization parameter changes.
Schema changes, such as adding indexes or materialized views.
Refreshing optimizer statistics.
Creating or changing SQL profiles.
Why isn’t it C?
SQL Access Advisor is diagnostic software that identifies and helps resolve SQL performance problems by recommending indexes, materialized views, materialized view logs, or partitions to create, drop, or retain.
Why isn’t it E
AWR DIFF
Performance degradation of the database occurs when your database was performing optimally in the past, but has over time gradually degraded to a point where it becomes noticeable to the users. AWR Compare Periods report enables you to compare database performance over time.
An AWR report shows AWR data during a period in time between two snapshots (or two points in time). An AWR Compare Periods report, on the other hand, shows the difference between two periods in time (or two AWR reports, which equates to four snapshots). Using AWR Compare Periods reports helps you to identify detailed performance attributes and configuration settings that differ between two time periods.
D SQL Performance Analyzer
D . SPA is tool to do that
D