When creating a table or index in parallel, each parallel execution server uses the values in the
STORAGE clause of the
CREATE statement to create temporary segments to store the rows. Therefore, a table created with a
NEXT setting of 4 MB and a
DEGREE of 16 consumes at least 64 megabytes (MB) of storage during table creation because each parallel server process starts with an extent of 4 MB. When the parallel execution coordinator combines the segments, some segments may be trimmed, and the resulting table may be smaller than the requested 64 MB.