SQL Type Summary
Use this page to view the SQL statements that were run on the database server, by the type of query, for example, SELECT or INSERT.
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.
Statement Type Filter
Use this filter to display the SQL statements of a specific type of query. The filter list shows only the types of SQL statements that are captured by SQL tracing. By default, the table displays the type of SQL statement that is selected on the Activity Summary page.
SQL Statement Search
Use this filter to search for an SQL statement in the table. Type any alphanumeric part of the SQL statement and then click Search. The table displays only the SQL statements that include what you typed.
SQL Type Summary
This table displays information about the SQL statements captured by SQL tracing. To view more details, click the drill-down icon.
- Count
- The number of times the statement was run.
- Avg Run Time
- The average amount of time required to run the statement, in seconds.
- 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.
- Completion Time
- The completion time of the most recent execution of the statement.
- SQL Statement
- The SQL statement. If the statement is compiled, the text of the statement is not displayed.