20100827ORACLE技术调优讲座PPT.pptVIP

The Sorting Process The server sorts in memory if the work can be done within an area smaller than the value (in bytes) of the SORT_AREA_SIZE parameter. If the sort needs more space than this value: 1. The data is split into smaller pieces, called sort runs; each piece is sorted individually. 2. The server process writes pieces to temporary segments on disk; these segments hold intermediate sort run data while the server works on another sort run. 3. The sorted pieces are merged to produce the final result. If SORT_AREA_SIZE is not large enough to merge all the runs at once, then subsets of th