Syntax options

    THRESHOLDS ARE ( val1 [,val2 [,val3] ] )

    Specifies one, two, or three threshold values. The threshold
    values represent a fullness percentage on a data page and
    establish four possible ranges of guaranteed free space on the
    data pages. When a data page reaches the percentage defined by a
    given threshold value, the space area management (SPAM) entry for
    the data page is updated to reflect the new fullness percentage
    and its remaining free space.

    The default thresholds are 70, 85, and 95 percent. If you
    specify only one or two values, unspecified values default to
    100 percent.

    You cannot specify the THRESHOLDS storage area parameter for
    single-file databases, and you cannot specify THRESHOLDS unless
    you also explicitly specify PAGE FORMAT IS MIXED. To specify
    thresholds for uniform storage areas, use the CREATE STORAGE MAP
    statement.

    For more information about setting space area management
    parameters, see the Oracle Rdb Guide to Database Maintenance.