TBLTBLNEXT configuration parameter

The TBLTBLNEXT configuration parameter specifies the next extent size of tblspace tblspace in the root dbspace. Set this parameter if you do not want the database server to automatically manage the extent size.

onconfig.std value
TBLTBLNEXT 0
values
From equivalent of 4 pages specified in kilobytes to the maximum chunk size minus three pages
units
Kilobytes
takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

Usage

If there is not enough space for a next extent in the primary chunk, the extent is allocated from another chunk. If the specified space is not available, the closest available space is allocated.


Copyright© 2019 HCL Technologies Limited