The DB_nK_CACHE_SIZE Initialization Parameters (110)
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.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-996321/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Understanding Initialization Parameters (85)
- Other SGA Initialization Parameters (96)
- Setting the Buffer Cache Initialization Parameters (108)
- 驗證一個和 initialization parameters pfile有關的052考試題
- Initialization
- JVM parametersJVM
- list initialization
- v$nls_parameters和nls_database_parametersDatabase
- Oracle Parallel ParametersOracleParallel
- The SPFILE Initialization Parameter
- TypeError: object() takes no parametersErrorObject
- Oracle Hidden ParametersOracle
- Unix kernel parameters for OracleOracle
- 初始化 (Initialization)
- Globalization Support Parameters in Views (178)View
- Special Characters in Initialization Parameter Files
- SKIP_UNUSABLE_INDEXES InitializationIndex
- OPTIMIZER_MODE Initialization Parameter
- Oracle cascading standby ParametersOracle
- File hash GET parameters for Django staticfilesDjango
- How to Change RabbitMQ Queue Parameters in Production?MQ
- [VRDevice] Initialization of device oculus failed.VRdevAI
- Rules Governing Initialization Parameter FilesGo
- DB_NAME Initialization Parameter (87)
- DB_DOMAIN Initialization Parameter (88)AI
- The SGA_TARGET Initialization Parameter (74)
- ORA-00382與DB_nK_CACHE_SIZE引數設定
- SAP Spartacus 中的 HTTP URL parametersHTTP
- The Builder pattern simulates named optional parameters(Java)UIJava
- User defined table type and table valued parameters
- Talking about Android Initialization ProcessAndroid
- Initialization Parameter Files and Server Parameter Files (287)Server
- Step 3: Create the Initialization Parameter File (61)
- DB_BLOCK_SIZE Initialization Parameter (92)BloC
- The SGA_MAX_SIZE Initialization Parameter (72)
- Android Audio HAL 介面介紹之 adev_set_parameters()和out_set_parameters()Androiddev
- Connections and Sessions (110)Session
- 110月18日