1. Using Oracle IT Analytics
  2. Maximize Performance and Availability
  3. Maximize Database Performance
  4. Analyze SQL Execution Performance
  5. Analyze SQL Execution Performance According to Database

Analyze SQL Execution Performance According to Database

From the details page of the database, you can view the list of SQL queries run on that particular database. Use this information to identify the top 10 degrading SQL statements by response time and highly varying SQL statements by relative variability.

Click a query to drill down further. The application displays the following information:

  • Response Time: View the maximum response time, minimum response time, average response time, and the percentage change in the response time.

  • SQL Performance: View the trend of SQL performance over time, measured by response time, active sessions, or executions per hour. You can also view execution statistics (for example, elapsed time in seconds per execution and in total).

Click the value in the SQL Text field to view the complete text of the SQL query.