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.

Note

Starting May 31st 2024 Ops Insights SQL Warehouse will be deprecated. For more information see MOS Note 3025469.1.
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