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 ...

Get Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.