SQL List
Use this page to review information about each execution of the SQL statement that was selected for query drill-down.
Prerequisite: SQL
tracing must be on to collect the information that is displayed on
this page. On the page, set the Trace State option
to On.
- SQL Statement
- The text of the SQL statement that was selected for query drill-down.
- List of Statement Executions
This list contains the following information for each execution of the SQL statement. To view more details, click the drill-down icon.
- SQL ID
- The assigned identifier for the SQL statement.
- Session ID
- The database session ID of the user running the SQL statement.
- User ID
- The user ID of the user running the SQL statement.
- Response Time
- The length of time required to run the SQL statement, in seconds.
- Rows/Second
- The average number of rows processed per second by the SQL statement.
- Rows Processed
- The number of rows processed by the SQL statement.
- Lock Wait Time
- The time spent waiting for locks to be removed while the SQL statement was running, in seconds.
- Wait I/O Time
- The average amount of time spent waiting for I/O while the SQL statement was running, in seconds.