Snapshot Level Database Application |
Logical Data Grouping dbase appl |
Monitor Switch Sort Sort |
Resettable |
Yes |
|
Event Type Database Connection Statement |
Logical Data Grouping db_event conn_event stmt_event |
|
Element Name Element Type |
total_sorts counter |
Description: The total number of sorts that have been executed.
Usage: At a database or application level, use this value with "Sort Overflows" to calculate the percentage of sorts that need more heap space. You can also use it with "Total Sort Time" to calculate the average sort time.
If the number of sort overflows is small with respect to the total sorts, then increasing the sort heap size may have little impact on performance, unless this buffer size is increased substantially.
At a statement level, use this element to identify statements which are performing large numbers of sorts. These statements may benefit from additional tuning to reduce the number of sorts. You can also use the SQL EXPLAIN statement to identify the number of sorts a statement performs. See the Administration Guide for more information.