When frequent large sorts are required, increase the value of SORTHEAP.
当需要频繁进行大型排序时，增加SORTHEAP的值。
Usually, the default value for SORTHEAP size (256 4kb pages) is adequate.
通常，SORTHEAP大小的缺省值(256个4kb页)就足够了。
To change the values of SORTHEAP and SHEAPTHRES, run the following commands.
要更改SORTHEAP和SHEAPTHRES的值，请运行以下命令。
Sort memory (controlled by the sheapthres_shr and the sortheap configuration parameters).
排序内存(由sheapthres_shr和sortheap配置参数控制)。
When this happens, increasing SORTHEAP just hides the performance problem — it does not fix it.
发生这种情况时，增加SORTHEAP只会隐藏性能问题-却无法修正它。
Overconfiguring SORTHEAP can lead to capacity problems as SHEAPTHRES will be exceeded more quickly.
将SORTHEAP 配置多了则导致容量问题，因为将会更快地超出 SHEAPTHRES。
This parameter should be at least two times the largest SORTHEAP defined for any database within the instance.
该参数至少应当是实例中任何数据库所定义的最大SORTHEAP的两倍。
In Step 4, we doubled SORTHEAP to 2048 to avoid sort overflows because some queries needed to create temporary tables.
在步骤4中，我们使SORTHEAP加倍到2048以避免排序溢出，因为某些查询需要创建临时表。
This will override the sortheap configuration parameter, and this is what the optimizer will use as the sortheap value.
这将重写sortheap配置参数，优化器也将之用作sortheap值。
This command is used to output a summary of the information used to tune the value of the SORTHEAP configuration parameter.
下面的命令输出sortheap配置参数值的调优信息。
If you increase SORTHEAP, determine whether the SHEAPTHRES parameter in the database manager configuration file also needs to be adjusted.
如果增加SORTHEAP，请确定是否还需要调整数据库管理器配置文件中的SHEAPTHRES参数。
For example, Figure 13 shows the Health Center recommending a new SORTHEAP value (note that details about the recommendation are available as well).
例如，图13显示，HealthCenter推荐了一个新的SORTHE ap值(请注意，还可以查看建议的详细信息)。
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参数最大值的倍数。
The columns include the previous value of the SORTHEAP configuration parameter (OLD), the current value (NEW), the minimum and maximum values computed by the memory tuner (min and max).
输出的信息包括 SORTHEAP配置参数以前的值 (OLD)、当前值 (NEW) 以及内存调优器计算出的最小值和最大值 (min 和 max)。
The columns include the previous value of the SORTHEAP configuration parameter (OLD), the current value (NEW), the minimum and maximum values computed by the memory tuner (min and max).
输出的信息包括 SORTHEAP配置参数以前的值 (OLD)、当前值 (NEW) 以及内存调优器计算出的最小值和最大值 (min 和 max)。
应用推荐