Name
SORT_SPACEMAP_SIZE
Synopsis
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.