Default Extent Size of Table Spaces (dft_extent_sz)

Configuration Type
Database

Parameter Type
Configurable

Default [Range]
32 [ 2 - 256 ]

Unit of Measure
Pages

Related Parameters
Default Prefetch Size (dft_prefetch_sz)

When a table space is created, EXTENTSIZE n can be optionally specified, where n is the extent size. If you do not specify the extent size on the CREATE TABLESPACE statement, the database manager uses the value given by this parameter.

Recommendation: In many cases, you will want to explicitly specify the extent size when you create the table space. Before choosing a value for this parameter, you should understand how you would explicitly choose an extent size for the CREATE TABLESPACE statement.