The DB_nK_CACHE_SIZE Initialization Parameters (110)

tsinglee發表於2008-01-02

The sizes and numbers of
nonstandard block size buffers are specified by the following initialization parameters:
■ DB_2K_CACHE_SIZE
■ DB_4K_CACHE_SIZE
■ DB_8K_CACHE_SIZE
■ DB_16K_CACHE_SIZE
■ DB_32K_CACHE_SIZE

Each parameter specifies the size of the buffer cache for the corresponding block size.
For example:
DB_BLOCK_SIZE=4096
DB_CACHE_SIZE=12M
DB_2K_CACHE_SIZE=8M
DB_8K_CACHE_SIZE=4M

In this example, the parameters specify that the standard block size of the database is
4K. The size of the cache of standard block size buffers is 12M. Additionally, 2K and
8K caches will be configured with sizes of 8M and 4M respectively.

Note: You cannot use a DB_nK_CACHE_SIZE parameter to size
the cache for the standard block size. For example, if the value of
DB_BLOCK_SIZE is 2K, it is invalid to set DB_2K_CACHE_SIZE.
The size of the cache for the standard block size is always
determined from the value of DB_CACHE_SIZE.

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-996321/,如需轉載,請註明出處,否則將追究法律責任。

相關文章