Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  NUMBER_OF_CLUSTER_NODES
    Syntax option:

    NUMBER OF CLUSTER NODES IS number-nodes

    Sets the upper limit on the maximum number of VMS cluster nodes
    from which users can access the shared database. Specify this
    clause only if the database named in the ALTER DATABASE statement
    refers to a multifile database. The default is 16 nodes. The
    range is 1 to 96 nodes. The actual maximum limit is the current
    VMS cluster node limit set by your system administrator.

    The Oracle Rdb root file data structures (.rdb) are mapped to
    shared memory, each such shared memory copy is known as an Rdb
    instance. When there is only one copy of shared memory containing
    root file information, several optimizations are enabled to
    reduce locking and root file I/O. activity. Specify NUMBER OF
    CLUSTER NODES is set to 1, or use the SINGLE INSTANCE clause to
    enable these optimizations.

    MULTIPLE INSTANCE means that the Oracle Rdb root file data
    structures are mapped on different system and are kept consistent
    through disk I/O. Such systems can not benefit from single
    instance optimizations. MULTIPLE INSTANCE is the default.
Close Help