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 SQLs based on the summary data, across databases. |
Identify degrading SQLs, variant SQLs, inefficient SQLs, and SQLs with multiple execution plans across databases. |
|
Analyze the performance of SQLs on the basis of the performance category. |
Analyze the performance of SQLs in different categories (degrading, variant, inefficient, and with plan changes) by using parameters such as percentage database time, number of SQLs, and size. |