Library /sys$common/syshlp/RDOHELP72.HLB  —  DEFINE_DATABASE, Format  db-wide-options-2  buffer-blocks
    The number of blocks Oracle Rdb allocates per buffer. Specify an
    unsigned integer greater than zero. If you do not specify this
    parameter, Oracle Rdb uses a buffer size that is three times the
    PAGE SIZE value.

    Buffer size is a global parameter and the number of blocks per
    page (or buffer) is constrained to less than 64 blocks per page.
    The page size can vary by storage area for multifile databases,
    so you should determine the page size of each storage area based
    on the sizes of records that will be stored in each storage area.

    When you choose the number of blocks per buffer, choose a number
    that is wholly divisible by all page sizes for all storage
    areas in your multifile database. For example, if your database
    has three storage areas with page sizes of 2, 3, and 4 blocks
    respectively, choosing a buffer size of 12 blocks will ensure
    optimal buffer utilization. If you choose a buffer size of 8, the
    storage area with a page size of 3 blocks will waste 2 blocks per
    buffer. Oracle Rdb reads as many pages as will fit into the buffer.
    In this case, Oracle Rdb reads two pages of 3 blocks apiece into the
    buffer, wasting 2 blocks.
Close Help