Database Queries By Highest 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 highest query execution time (in seconds) for a given time frame.
Table: Database Queries By Highest 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). |
Run Time | Date and time when the SQL query was run. |
Rows Processed | Number of database rows processed by the query. |
Total Time (Seconds) | Time required to run the SQL query on the database in seconds. |
SQL Query | The actual SQL query that was run on the IT Analytics database. |