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 is the upper limit of the next extent size
Default value: 2 GB - 5 * <database block size>
0 means unlimited next extent size
The BRCONNECT next function does not change the NEXT_EXTENT storage parameter of tables or indexes to a value greater than the value specified in this parameter.
Example
This command sets the upper limit for the next extent size to 1 MB:
next_max_size = 1M