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

    NUMBER IS number-glo-buffers

    Specifies the total number of buffers in the global buffer pool.
    This number appears as "global buffer count" in RMU Dump command
    output. Base this value on the database users' needs and the
    number of attachments. The default is the maximum number of
    attachments multiplied by 5.

                                   NOTE

       Do not confuse the NUMBER IS parameter with the NUMBER OF
       BUFFERS IS parameter. The NUMBER OF BUFFERS IS parameter
       determines the default number of buffers Oracle Rdb
       allocates to each user's process that attaches to the
       database. The NUMBER OF BUFFERS IS parameter applies to,
       and has the same meaning for, local and global buffering.
       The NUMBER IS parameter has meaning only within the context
       of global buffering.

    You can override the default number of user-allocated buffers by
    defining a value for the logical name RDM$BIND_BUFFERS. For more
    information on user-allocated buffers, see Oracle Rdb7 Guide to
    Database Performance and Tuning.

    Although you can change the NUMBER IS parameter on line, the
    change does not take effect until the next time the database is
    opened.
Close Help