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.