The total number of hash joins that requested sort heaps after the sort heap threshold (SHEAPTHRES) was reached. (Consequently, these joins are allotted limited amounts of sort heap space.) A high number might indicate a need for larger SHEAPTHRES value.
Note: In a multiple-partition database, information is presented for each active partition on the system. An All Nodes row keeps a running total for all partitions. In a single-partition database, only the All Nodes information is presented.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
