A configuration parameter configures how many buffers 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 “Configuring resources for parallel sorting” on page 218 in the Performance and Tuning: Optimizer book for more information.
