Ideally, you should set the sort heap threshold (SHEAPTHRES) parameter to a reasonable multiple of the largest SORTHEAP parameter you have in your database manager instance.
理想情况下，应当将排序堆阈值(SHEAPTHRES)参数合理地设置为在数据库管理器实例中设置的SORTHEAP参数最大值的倍数。
Always keep the threshold high enough to fulfill the total sort heap required by all the applications, if not application request for a piped sort will be rejected.
总是要让阈值保持足够大以便满足所有应用程序所需的总排序堆。
The Sort heap Threshold (sheapthres, sheapthres_shr).
排序堆的阈值(sheapthres, sheapthres_shr)。
If the value of Piped sorts ratio is low, you should consider increasing the sort heap threshold (sheapthres) for better sort performance.
如果管道排序率的值很低，您就应该考虑增加排序堆阈值(sheapthres)以获得更高的排序性能。
Tuning the sort heap threshold (sortheapthres).
调优排序堆阈值(sortheapthres)。
If the value of Post threshold sorts ratio is high, you should either increase the sort heap threshold (sheapthres), or adjust applications to use fewer or smaller sorts via SQL query changes.
如果阈值后排序率很高，您就应该增加排序堆阈值(sheapthres)，或通过修改SQL查询调整应用程序以使用较少或较小的排序。
Post threshold sorts is the number of sorts that have requested heaps after the sort heap threshold has been exceeded.
阈值后排序(Post threshold sort)是在超出排序堆阈值之后，请求堆的排序数目。
Sorts that start after the sort heap threshold has been reached may not receive an optimum amount of memory to execute.
在到达排序堆阈值之后开始的排序可能不会接收到最合适的内存数量去执行。
Sorts that start after the sort heap threshold has been reached may not receive an optimum amount of memory to execute.
在到达排序堆阈值之后开始的排序可能不会接收到最合适的内存数量去执行。
应用推荐