Show TOC

Syntax documentationnext_max_size Locate this document in the navigation structure

This parameter defines the upper limit for the next extent size, in KB, MB, or GB.

Syntax Syntax

  1. next_max_size = <size>
End of the code.

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 Example

This command sets the upper limit for the next extent size to 1 MB:

next_max_size = 1M

End of the example.