Typical Tasks for Analyzing SQL Performance
Here’s a list of tasks to analyze the performance of your SQL requests by using the SQL Analytics application of Oracle IT Analytics.
Task | Description | More Information |
---|---|---|
Monitor the performance of SQL statements based on the summary data, across databases. | Identify degrading SQL statements, variant SQL statements, inefficient SQL statements, and SQL statements with multiple execution plans across databases. | Monitor SQL Performance Across Databases |
Analyze the performance of SQL statements on the basis of the performance category. | Analyze the performance of SQL statements in different categories (degrading, variant, inefficient, and with plan changes) by using parameters such as percentage database time, number of SQL statements, and size. | Analyze the Performance of SQL Statements |