Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.
A.
Change in the Oracle Database version
B.
Change in your network infrastructure
C.
Change in the hardware configuration of the database server
D.
Migration of database storage from non-ASM to ASM storage
E.
Database and operating system upgrade
Explanation:
Oracle 11g/12c 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:
* (E) Database, operating system, or hardware upgrades.
* (A,C) 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.
A,C,E
https://docs.oracle.com/database/121/RATUG/GUID-310A0AA6-38C9-49A1-97C1-9BED682E654A.htm#RATUG170
In both cases, you can execute the SQL workload remotely on a separate database using a database link. SQL Performance Analyzer will establish a connection to the remote database using the database link, execute the SQL statements on that database, collect the execution plans and run-time statistics for each SQL statement, and store the results in a SQL trial on the local database that can be used for later analysis. This method is useful in cases where you want to:
Test a database upgrade
Execute the SQL workload on a system running another version of Oracle Database
Store the results from the SQL Performance Analyzer analysis on a separate test system
Perform testing on multiple systems with different hardware configurations
Use the newest features in SQL Performance Analyzer even if you are using an older version of Oracle Database on your production system