sheapthres

  • Web排序堆阈值；排序堆阈值参数

Web Definition

1.
排序堆阈值
· 理想情况下，应当将排序堆阈值（SHEAPTHRES）参数合理地设置为在数据库管理器实例中设置的 SORTHEAP 参数最大值 …
www.360doc.com|Based on 130 pages
2.
排序堆阈值参数
理想情况下，应当将排序堆阈值参数 (SHEAPTHRES) 合理地设置为在数据库管理器实例中设置的 SORTHEAP 参数最大值的 …
www.ibm.com|Based on 8 pages

Sample Sentence

Definition:
AllAll,排序堆阈值排序堆阈值,排序堆阈值参数排序堆阈值参数
Category:AllAll,OralOral,WrittenWritten,TitleTitle,TechnicalTechnical
Source:AllAll,DictionaryDictionary,WebWeb
Difficulty:AllAll,EasyEasy,MiddleMiddle,HardHard
1.
The maximum amount of memory used for shared sorts is controlled by the sheapthres_shr database parameter.
用于共享排序的最大内存量是由sheapthres_shr数据库参数指定的。
yòng yú gòng xiǎng pái xù de zuì dà nèi cún liàng shì yóu sheapthres_shr shù jù kù cān shù zhǐ dìng de 。
www.ibm.com
2.
For shared sorts, SHEAPTHRES is a database-wide hard limit on the total amount of memory consumed by shared sorts at any given time.
对于共享排序，SHEAPTHRES是对共享排序在任何给定的时间可以消耗的全部内存的数据库级“硬”限制。
duì yú gòng xiǎng pái xù , SHEAPTHRES shì duì gòng xiǎng pái xù zài rèn hé gěi dìng de shí jiān kě yǐ xiāo hào de quán bù nèi cún de shù jù kù jí " yìng " xiàn zhì 。
www.ibm.com
3.
If you increase SORTHEAP, determine whether the SHEAPTHRES parameter in the database manager configuration file also needs to be adjusted.
如果增加SORTHEAP，请确定是否还需要调整数据库管理器配置文件中的SHEAPTHRES参数。
rú guǒ zēng jiā SORTHEAP , qǐng què dìng shì fǒu hái xū yào tiáo zhěng shù jù kù guǎn lǐ qì pèi zhì wén jiàn zhōng de SHEAPTHRES cān shù 。
www.ibm.com
4.
A general rule of thumb is to set SHEAPTHRES to at least 10 * SORTHEAP.
通常的经验是将SHEAPTHRES至少设置为10*SORTHEAP。
tōng cháng de jīng yàn shì jiāng SHEAPTHRES zhì shǎo shè zhì wèi shí xīng hào SORTHEAP 。
www.ibm.com
5.
If the value of Piped sorts ratio is low, you should consider increasing the sort heap threshold (sheapthres) for better sort performance.
如果管道排序率的值很低，您就应该考虑增加排序堆阈值（sheapthres）以获得更高的排序性能。
rú guǒ guǎn dào pái xù lǜ de zhí hěn dī , nín jiù yīng gāi kǎo lǜ zēng jiā pái xù duī yù zhí ( sheapthres ) yǐ huò de gèng gāo de pái xù xìng néng 。
www.ibm.com
6.
Overconfiguring SORTHEAP can lead to capacity problems as SHEAPTHRES will be exceeded more quickly.
将SORTHEAP配置多了则导致容量问题，因为将会更快地超出SHEAPTHRES。
jiāng SORTHEAP pèi zhì duō le zé dǎo zhì róng liàng wèn tí , yīn wèi jiāng huì gèng kuài de chāo chū SHEAPTHRES 。
www.ibm.com
7.
The size of the private sort memory area is unrestricted. The SHEAPTHRES parameter is applied differently for private and shared sorts
私有排序内存区的大小是不受限制的。
sī yǒu pái xù nèi cún qū de dà xiǎo shì bù shòu xiàn zhì de 。
www.ibm.com
8.
Sort memory (controlled by the sheapthres_shr and the sortheap configuration parameters)
排序内存（由sheapthres_shr和sortheap配置参数控制）
pái xù nèi cún ( yóu sheapthres_shr hé sortheap pèi zhì cān shù kòng zhì )
www.ibm.com
9.
In general SHEAPTHRES should be set to a multiple of SORTHEAP
通常应将SHEAPTHRES设置为SORTHEAP的倍数。
tōng cháng yīng jiāng SHEAPTHRES shè zhì wèi SORTHEAP de bèi shù 。
www.ibm.com