Use the number of sort buffers configuration parameter to set the number of buffers that can be used in cache to hold pages from the input tables. In addition, parallel sorting can benefit from large I/O in the cache used to perform the sort.
See Chapter 5, “Parallel Query Processing” in Performance and Tuning Series: Query Processing and Abstract Plans.
