December 2002
Intermediate to advanced
928 pages
85h 29m
English
SORT_SPACEMAP_SIZE
Value: operating system dependent
Default: operating system dependent
Specifies the size, in bytes, of the sort space map. This parameter should be adjusted only if very large indexes exist. A sort automatically increases its space map if necessary, but it does not necessarily do so when it will make best use of disk storage. The sort makes optimal use of disk storage if SORT_SPACEMAP_SIZE is set to total_sort_bytes = (number_of_records) * [sum_of_average_column_sizes + (2 * number_of_columns)]. Obsolete with Oracle8i.