The Post Threshold Sorts alarm becomes active when a sort has been requested after the sort heap threshold has been reached. Sorts that start after the sort heap threshold (sheapthres configuration parameter) has been reached may not receive all the memory they need to run efficiently. By adjusting the sort heap threshold and sort heap size configuration parameters, you can improve sort operations and overall system performance.
This alarm has been predefined with a Low severity level. The underlying metric for this alarm can be adjusted to suit your environment by using the Metric Editor.
If post-threshold sort values are high, you can try the following possible solutions:
Increasing SHEAPTHRES
Making SQL query changes that allow applications to use fewer or smaller sorts.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
