SQL Monitor View
The SQL Monitor view allows you to identify top business processes with performance issues and navigate to the SQL statements that cause such issues. This view uses SQL Monitor data to search and display results.
The search feature in the SQL Monitor view uses the Aggregation By
criteria to consolidate data based on any of the following options:
- Request: Use this option to aggregate SQL Monitor data based on the request entry point. Request entry points are business processes such as transactions or reports that an end user initiates or has initiated from an external source.
- Source Code Position : Use this option to aggregate SQL Monitor data that uses the same SQL statement.
- None: Use this option if you do not want to aggregate data. The SQL Monitor data appears in the search results.
To sort data, the search feature uses specific database parameters in Order
By such as:
- Total number of database executions
- Total database execution time
- Total database records