Instance Sort & Join Exception Pct graph
The Instance Sort & Join Exception Pct graph relates the sort exception counts shown in the Instance Sort & Hash Join Exceptions graph to the total number of sort and hash joins, respectively, as percentages. These percentages, gathered for the selected database over consecutive monitoring intervals, are shown in the following series:
-
Post thresh sorts —Plots the percentage of sorts that were allocated less memory than the amount defined by the database SORTHEAP parameter. The database manager allocated this smaller sort heap to avoid exceeding the SHEAPTHRES value—the total amount of memory in the database committed to active sorts.
-
Post thresh joins —Plots the percentage of hash joins that were allocated less memory than the amount defined by the database SORTHEAP parameter. The database manager allocated this smaller sort heap to avoid exceeding the SHEAPTHRES value—the total amount of memory in the database committed to active sorts.
-
Piped sort rejects —Plots the percentage of sorts that were non-piped—that is, that needed to route the final, sorted data through temporary files before sending it to the requester. Temporary files were used because the sort heap was not large enough to serve as both a sorting workspace and a temporary storage location for the sorted data.
