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