Next-Extent Size
The number of kilobytes that the database server allocates
for a next extent is, in general, equal to the size of a next extent,
as specified in the SQL statement
CREATE TABLE. However, the actual size of the next-extent allocation
might deviate from the specified size because the allocation procedure
takes into account the following three factors:
- Number of existing extents for this tblspace
- Availability of contiguous space in the chunk and dbspace
- Location of existing tblspace extents
The effect of each of these factors on next-extent allocation is explained in the paragraphs that follow and in Figure 1.