This parameter defines the upper limit for the next extent size, in KB, MB, or GB.
Syntax:
next_max_size = <size>where
<size>: <n>K|<n>M|<n>G for the upper limit of the next extent sizeDefault: 2 GB - 5 * <database block size>
0 means unlimited next extent size
The
BRCONNECT next function does not change the NEXTEXTENT storage parameter of tables or indexes to a value greater than the value specified in this parameter.To set the upper limit for the next extent size to 1 MB, enter the following:
next_max_size = 1M