Database Queries Doing Full Table Scans
This report is accessible only to the IT Analytics Portal super user.
This report is located at:
System Administration Reports > Database Queries Doing Full Table Scans
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 Doing Full Table Scans
Column name | Description |
|---|---|
DB User | Name of the database user account used to run the SQL query. |
Disk Reads | Disk I/O accounted to the SQL query. |
# of Executions | Number of times the SQL query was run during the specified report duration. |
SQL ID | The unique identifier Oracle assigns to each unique SQL query. |
Last Load Time | Date and time when the SQL query was last parsed in Oracle library cache. |
SQL Query | The actual SQL query that was run on the IT Analytics database. |