Analyze SQL Performance
Using the SQL Analytics application of Oracle IT Analytics, you can analyze the SQL performance problems for enterprise-wide applications across a fleet of databases. In addition, Oracle IT Analytics provides trends and key insights to SQL performance issues thereby helping you to be proactive in avoiding future problems.
Note:
You need to have Oracle Diagnostic Pack installed on your target database to be able to use SQL Analytics.The SQL Analytics application home page displays the following sections:
- Performance Summary
- Performance Analysis
- View the degrading SQLs, variant SQLs, inefficient SQLs, and SQLs with plan changes.
- View the SQLs with the highest CPU and I/O usage.
- Analyze the performance of SQLs based on these categories – degrading, inefficient, variant, and with plan changes.
- Perform a SQL-wise performance analysis with the help of the average response time statistics.
- View the number of plans per SQL and get further insights to SQL performance based on details such as best performing plan, most executed plan, plan with the most I/O, and so on.
SQL Analytics can be also be used to analyze SQL performance of both types of Autonomous Databases - Shared: Autonomous Data Warehouse – Shared and Autonomous Transaction Processing – Shared. For more information on Autonomous Databases - Shared, see: Discover Autonomous Databases in Using Oracle Database Management for Autonomous Databases.