Synopsis

Values:DB_BLOCK_SIZE to SORT_AREA_SIZE

Default:SORT_AREA_SIZE

Sets the maximum amount, in bytes, of user memory retained after a completed sort run. The size of retained memory controls the size of the read buffer, which is used to maintain a portion of the sort in memory. Larger values permit more sorts to be performed in memory; however, multiple sort spaces of this size may be allocated.