Setting the Buffer Cache Initialization Parameters (108)

tsinglee發表於2008-01-02

The buffer cache initialization parameters
determine the size of the buffer cache component of the SGA. You use them to specify
the sizes of caches for the various block sizes used by the database. These initialization
parameters are all dynamic.

If you intend to use multiple block sizes in your database, you must have the
DB_CACHE_SIZE and at least one DB_nK_CACHE_SIZE parameter set. Oracle
Database assigns an appropriate default value to the DB_CACHE_SIZE parameter, but
the DB_nK_CACHE_SIZE parameters default to 0, and no additional block size caches
are configured.

The size of a buffer cache affects performance. Larger cache sizes generally reduce the
number of disk reads and writes. However, a large cache may take up too much
memory and induce memory paging or swapping.

[@more@]

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

相關文章