Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability

CHAPTER

10

SQL Performance Analyzer

Aproduction database is typically modified only when necessary, and this is why most DBAs are extremely careful with every modification performed on production databases. Changes, however, are impossible to avoid—whether they be major changes, such as migrating to a new server or upgrading the database version, or minor ones, such as changing a database parameter or creating a new index. Regardless of the type change requested, thorough planning and testing is needed to verify that a change will not break applications or negatively impact their performance. Oracle offers two solutions for performing change ...