This section reports contention for the sort buffers used for parallel sorts. Parallel sort buffers are used by:
Producers – the worker processes returning rows from parallel scans
Consumers – the worker processes performing the parallel sort
If the number of waits is high, you can configure number of sort buffers to a higher value.
See “Sort buffer configuration guidelines” on page 223 in Performance and Tuning: Optimizer for guidelines.
