As a Database Administrator, you can use SQL Performance Analyzer in SQL Performance Watch to assess the impact of system changes on the overall execution time of the SQL workload and on the response time of every individual SQL statement in the workload.

Using SQL Performance Analyzer, you can:

• Predict the impact of system changes on SQL workload response time
• Analyze performance differences before and after system change
• Obtain a fine-grained performance analysis of individual SQL statements

To access SQL Performance Analyzer in SQL Performance Watch:

1. Sign in to the Oracle Cloud Infrastructure console.
2. Open the navigation menu, click Observability & Management. Under Database Management, click SQL Performance Watch.
3. On the SQL Performance Watch Summary page, click the name of the SQL Performance Watch-enabled database.

The SQL Performance Watch home page for the database is displayed. You must set the Advanced diagnostics preferred credential to view data and perform tasks on this page. If the preferred credential is not set, a message is displayed on the top of the page and you can click the link to set the preferred credential. For information, see Set Advanced Diagnostics Preferred Credential.

On the SQL Performance Watch home page, you can:

• View database details, such as the database type and version
• Create a SQL Performance Analyzer task, which captures all the data about a complete SQL Performance Analyzer analysis by:
  1. Creating a pre-change SQL trial to measure performance
  2. Creating a post-change SQL trial to measure performance
  3. Comparing pre-change and post-change trials to estimate the impact on performance
• Monitor SQL Performance Analyzer tasks and view SQL Performance Analyzer comparison reports
• Configure and use SPA Quick Check to validate the potential impact of a system change to the database workload before you implement the change