- Configuration Type
- Database
- Parameter Type
- Configurable
- Default [Range]
- 256 [ 16 - 524 288 ]
- Unit of Measure
- Pages (4KB)
- When Allocated
- As needed to perform sorts
- When Freed
- When sorting is complete
- Related Parameters
- Sort Heap Threshold (sheapthres)
This parameter defines the maximum number of private memory pages to be
used for private sorts, or the maximum number of shared memory pages to be
used for shared sorts. If the sort is a private sort, then this
parameter affects agent private memory. If the sort is a shared sort,
then this parameter affects the database shared memory. Each sort has a
separate sort heap that is allocated as needed, by the database
manager. This sort heap is the area where data is sorted. If
directed by the optimizer, a smaller sort heap than the one specified by this
parameter is allocated using information provided by the optimizer.
Recommendation:
- Appropriate indexes can minimize the use of the sort heap.
- Increase the size of this parameter when frequent large sorts are
required.
- When increasing the value of this parameter, you should examine whether
the sheapthres parameter in the database manager configuration file
also needs to be adjusted.
- The sort heap size is used by the optimizer in determining access
paths. You should consider rebinding applications (using the REBIND
PACKAGE command) after changing this parameter.