Synopsis

Values:AUTO, TRUE, or FALSE

Default:AUTO

Controls whether sort data will bypass the buffer cache to write intermediate sort results to disk. If memory and temporary space are plentiful on the system, this parameter can improve sort performance. When the parameter is set to the default of AUTO, and the value of the sort area size is greater than ten times the block size, memory for this function is allocated from the sort area. When the parameter is set to TRUE, additional buffers are allocated from memory during each sort, and additional temporary segment space can be required. When the parameter is set to FALSE, the sorts that write to disk write through the buffer cache.