Database Queries By Total Execution Time
This report is accessible only to the IT Analytics Portal super user.
This report is located at:
System Administration Reports > Database Queries By Highest Execution Time
Use this report to diagnose Oracle database performance issues. This report lists the database queries ordered by total execution Time (in seconds) for a given time frame.
Table: Database Queries By Total Execution Time
Column name | Description |
|---|---|
DB User | Name of the database user account used to run the SQL query. |
Module | Name of the Program executing the SQL Query (e.g. SQLPlus.exe, JDBC Thin Client). |
Avg. Execution Time (Seconds) | Average time duration taken by the SQL query to run over the time specified while generating the report. |
# of Executions | Number of times the SQL query was run during the specified report duration. |
Avg. Executions Per Day | Average count of the SQL Query executions each day. |
Total Time (Seconds) | Time required to run the SQL query on the database in seconds. |
Earliest Run Time | Date and time of the first query execution found in Oracle library cache. |
Last Run Time | Date and time of the last query execution found in Oracle library cache. |
SQL Query | The actual SQL query that was run on the IT Analytics database. |