Extent Management
Hi,
Easy one here, but a bit confusing documentation regardin extent storage clauses and LMT's.
According to the Concepts manual regarding extent management and storage clauses:
"The storage parameters
According to the Administrator's Guide storage clauses:
"
Easy one here, but a bit confusing documentation regardin extent storage clauses and LMT's.
According to the Concepts manual regarding extent management and storage clauses:
"The storage parameters
INITIAL
,
NEXT
,
PCTINCREASE
, and
MINEXTENTS
cannot be specified at the tablespace level for locally managed
tablespaces. They can, however, be specified at the segment level. In
this case,
INITIAL
,
NEXT
,
PCTINCREASE
, and
MINEXTENTS
are used together to compute the initial size of the segment. After the
segment size is computed, internal algorithms determine the size of
each extent."
According to the Administrator's Guide storage clauses:
"
NEXT
"
In a dictionary-managed tablespace, the
size, in bytes, of the next incremental extent to be allocated for a
segment. The second extent is equal to the original setting for
0