Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  EXTENT clause
    Syntax options:

    EXTENT ENABLED | EXTENT DISABLED

    Enables or disables extents. Extents are ENABLED by default
    and can be changed on line; however, the new extents are not
    immediately effective on all nodes of a cluster. On the node on
    which you have changed extents, the new storage area extents are
    immediately effective for all users. The new storage area extents
    become effective as the database is attached on each node of the
    cluster.

    You can encounter performance problems when creating hashed
    indexes in storage areas with the mixed page format if the
    storage area was created specifying the wrong size for the area
    and if extents are enabled. By disabling extents, this problem
    can be diagnosed early and corrected to improve performance.
Close Help