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

    GLOBAL BUFFERS ARE ENABLED | GLOBAL BUFFERS ARE DISABLED

    Specifies whether or not Oracle Rdb maintains one global buffer
    pool per VMScluster node for each database. By default, Oracle
    Rdb maintains a local buffer pool for each attach (GLOBAL BUFFERS
    ARE DISABLED). For more than one attach to use the same page,
    each must read it from the disk into their local buffer pool.
    A page in the global buffer pool can be read by more than one
    attach at the same time, although only one attach reads the page
    from the disk into the global buffer pool. Global buffers improve
    performance because the I/O is reduced, and memory is better
    utilized.

                                   NOTE

       If GALAXY SUPPORT is enabled, then a single global buffer
       pool is shared by all Galaxy nodes.
Close Help