Snapshot Information Level Database |
API Structure(s) sqlm_dbase |
Monitor Group Basic |
Resettable |
No |
|
API Element Name Element Type |
active_sorts counter |
Description: The number of sorts in the database that currently have a sort heap allocated.
Usage: Use this value in conjunction with "Total Sort Heap Allocated" to determine the average sort heap space used by each sort. If the sortheap configuration parameter is substantially larger than the average sort heap used, you may be able to lower the value of this parameter. (See the Administration Guide for more details.)
This value includes heaps for sorts of temporary tables that were created during relational operations.
[ Top of Page | Table of Contents | Glossary | Index ]