next_max_size

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 size

Default: 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