1Z0-060 · Question #83
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.
The correct answer is A. Change in the Oracle Database version C. Change in the hardware configuration of the database server E. Database and operating system upgrade. Oracle 11g/12cmakes 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…
Question
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.
Options
- AChange in the Oracle Database version
- BChange in your network infrastructure
- CChange in the hardware configuration of the database server
- DMigration of database storage from non-ASM to ASM storage
- EDatabase and operating system upgrade
How the community answered
(16 responses)- A88% (14)
- B6% (1)
- D6% (1)
Explanation
Oracle 11g/12cmakes 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.
Topics
Community Discussion
No community discussion yet for this question.