The Piped Sort Rejects alarm becomes active when piped sort requests are rejected. A piped sort is rejected if the sort heap threshold is exceeded at the time the sort heap is allocated.
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.
Increasing the sort heap threshold for the instance, or the sort heap space for the database can improve piped sort acceptance.
