TBLTBLFIRST configuration parameter

Use the TBLTBLFIRST configuration parameter if you want to specify the first 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
TBLTBLFIRST 0
values
From the equivalent of 250 pages specified in kilobytes to the size of the first chunk minus the space needed for any system objects.
units
Kilobytes in multiples of page size
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

You might want to specify first and next extent sizes to reduce the number of tblspace tblspace extents and reduce the frequency of situations when you need to place the tblspace tblspace extents in non-primary chunks. (A primary chunk is the initial chunk in a dbspace.)

You can use oncheck -pt and oncheck -pT to show the first and next extent sizes of a tblspace tblspace.

If you want to configure the first extent for a non-root dbspace, use the onspaces utility.


Copyright© 2019 HCL Technologies Limited