HELPLIB.HLB  —  RMU72  Copy Database, Command Qualifiers, Local Buffers
    Local_Buffers=local-buffer-options

    Allows you to change the default local buffer parameters when you
    copy a database. The following options are available:

    o  Number=number-buffers

       Use this option to specify the number of local buffers that
       will be available for all users. You must specify a number
       between 2 and 32,767 for the number-buffers parameter.

    o  Size=buffer-blocks

       Use this option to specify the size (specified in blocks) for
       each buffer. You must specify a number between 2 and 64 for
       the buffer-blocks parameter.

       If you specify a value smaller than the size of the largest
       page defined, Oracle RMU automatically adjusts the size of
       the buffer to hold the largest page defined. For example, if
       you specify the Local_Buffers=Size=8 qualifier and the largest
       page size for the storage areas in your database is 64 blocks,
       Oracle RMU automatically interprets the Local_Buffers=Size=8
       qualifier as though it were a Local_Buffers=Size=64 qualifier.

       Take great care when selecting a buffer size; a poor choice
       causes performance to suffer greatly.

       The value specified for the buffer-blocks parameter determines
       the number of blocks for each buffer, regardless of whether
       local buffering or global buffering is enabled for the
       database.

    If you do not specify a Local_Buffers option, the database is
    copied with the values that are in effect for the database you
    are copying.
Close Help