Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to
analyze impact 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.
ACE
A&B&C&E
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.
ACE