Setting the Buffer Cache Initialization Parameters (108)
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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-996319/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- The DB_nK_CACHE_SIZE Initialization Parameters (110)
- Understanding Initialization Parameters (85)
- Other SGA Initialization Parameters (96)
- Buffer Cache 原理
- cache buffer chainAI
- IO之核心buffer----"buffer cache"
- Buffer Cache Hit Ratio
- Oracle Buffer Cache原理Oracle
- Oracle database buffer cacheOracleDatabase
- CACHE BUFFER CHAINSAI
- Database Buffer Cache (79)Database
- page cache與buffer cache的關係
- Oracle Cache Buffer ChainsOracleAI
- linux cache and buffer【轉】Linux
- Latch: cache buffer chains (%)AI
- BUFFER CACHE尋找流程
- buffer cache logical structure!Struct
- buffer cache部分原理(LRU)
- Organization of the Database Buffer Cache (80)Database
- Size of the Database Buffer Cache (82)Database
- oracle buffer cache管理機制_buffer cache dump與lru機制小記Oracle
- DB_CACHE_SIZE Initialization Parameter (109)
- 【BUFFER】Oracle buffer cache之 latch 學習記錄Oracle
- buffer與cache的區別
- database buffer cache之我見Database
- buffer cache基本知識點
- BUFFER CACHE 基礎知識
- [Oracle Script] Buffer Cache Hit RatioOracle
- 等待模擬-cache buffer chainAI
- Buffer cache的執行原理
- Buffer和Cache的區別
- Buffer 與 Cache 的區別
- Cache Buffer Chain Latch等待事件AI事件
- Cache 和 Buffer的區別
- why Buffer Cache Hit Ratio < 0
- buffer cache實驗5-latch:cache buffers chainAI
- 【Cache】將常用的“小表”快取到Buffer Cache快取
- Buffer Cache以及buffer busy waits/gc相關事件AIGC事件