Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  CREATE  DATABASE  Arguments  MULTITHREAD_AREA_ADDITIONS
    Specifies whether Oracle Rdb creates all storage areas in
    parallel, creates a specified number in parallel, or creates
    areas serially.

    This clause lets you determine the number of storage areas
    to be created in parallel, possibly saving time during the
    initial database creation. However, if you specify a large
    number of storage areas and many areas share the same device,
    multithreading may cause excessive disk head movement, which may
    result in the storage area creation taking longer than if the
    areas were created serially. In addition, if you specify a large
    number of storage areas, you may exceed process quotas, resulting
    in the database creation failing.

    This setting is not saved as a permanent database attribute. It
    is used only during the execution of the CREATE DATABASE, ALTER
    DATABASE, or IMPORT statements.

    If you do not specify the MULTITHREAD AREA ADDITIONS clause, the
    default is to create one storage area at a time. If you specify
    the MULTITHREAD AREA ADDITIONS clause, but do not specify an
    option, the default is all areas are created in parallel.
Close Help