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.