Snapshot Information Level Database Application |
API Structure(s) sqlm_dbase sqlm_appl |
Monitor Group Sort Sort |
Resettable |
Yes |
|
Event Information Level Database Connection Statement |
API Structure(s) sqlm_db_event sqlm_conn_event sqlm_stmt_event |
|
API 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.
[ Top of Page | Table of Contents | Glossary | Index ]