Initianization Parameter (3) : DB_CACHE_SIZE
Parameter type : Big integer
Syntax : DB_CACHE_SIZE = integer [K | M | G]
Default value : If SGA_TARGET is set: If the parameter is not specified, then the default
is 0 (internally determined by the Oracle Database). If the parameter is
specified, then the user-specified value indicates a minimum value for
the memory pool.
If SGA_TARGET is not set, then the default is either 48 MB or 4MB *
number of CPUs * granule size, whichever is greater
Modifiable : ALTER SYSTEM
Basic : No
DB_CACHE_SIZE specifies the size of the DEFAULT buffer pool for buffers with the
primary block size (the block size defined by the DB_BLOCK_SIZE initialization
parameter).
The value must be at least 4M * number of cpus * granule size (smaller
values are automatically rounded up to this value). A user-specified value larger than
this is rounded up to the nearest granule size. A value of zero is illegal because it is
needed for the DEFAULT memory pool of the primary block size, which is the block
size for the SYSTEM tablespace.[@more@]
Syntax : DB_CACHE_SIZE = integer [K | M | G]
Default value : If SGA_TARGET is set: If the parameter is not specified, then the default
is 0 (internally determined by the Oracle Database). If the parameter is
specified, then the user-specified value indicates a minimum value for
the memory pool.
If SGA_TARGET is not set, then the default is either 48 MB or 4MB *
number of CPUs * granule size, whichever is greater
Modifiable : ALTER SYSTEM
Basic : No
DB_CACHE_SIZE specifies the size of the DEFAULT buffer pool for buffers with the
primary block size (the block size defined by the DB_BLOCK_SIZE initialization
parameter).
The value must be at least 4M * number of cpus * granule size (smaller
values are automatically rounded up to this value). A user-specified value larger than
this is rounded up to the nearest granule size. A value of zero is illegal because it is
needed for the DEFAULT memory pool of the primary block size, which is the block
size for the SYSTEM tablespace.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-978024/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Initianization Parameter (5) : THREADthread
- Initianization Parameter (4) : CPU_COUNT
- Initianization Parameter (1) : DB_BLOCK_SIZEBloC
- Initianization Parameter (2) : DB_BLOCK_BUFFERSBloC
- DB_CACHE_SIZE Initialization Parameter (109)
- Step 3: Create the Initialization Parameter File (61)
- Parameter index out of range (3 > number of parameters, which is 2).Index
- DB_BLOCK_SIZE and DB_CACHE_SIZE in OracleBloCOracle
- Initialization Parameter Files and Server Parameter Files (287)Server
- Oracle ParameterOracle
- Required parameter $xxx follows optional parameter $yyyUI
- pyhton3解決”tuple parameter unpacking is not supported”問題
- The SPFILE Initialization Parameter
- Sessions & Processes parameterSession
- Import parameter: STATISTICSImport
- Export Parameter : BufferExport
- Export Parameter : QueryExport
- MySQL過程報 Parameter number N is not an OUT parameter錯誤MySql
- 使用DBMS_UTILITY.get_parameter_value檢視session的parameterSession
- Oracle Server Parameter FilesOracleServer
- What Is a Server Parameter File?Server
- Create a New Parameter ID
- 10.2.0.2 init parameter
- Export Parameter : ConsistentExport
- Export Parameter : CompressExport
- LTSPICE parameter設定
- 學習動態效能表(14)--V$PARAMETER&V$SYSTEM_PARAMETER
- python parameter引數Python
- jquery pass parameter to ajax callbackjQuery
- Special Characters in Initialization Parameter Files
- Exporting the Server Parameter FileExportServer
- Errors and Recovery for the Server Parameter FileErrorServer
- skip_unusable_index parameterIndex
- BATCHSQL--GoldenGate ParameterBATSQLGo
- OPTIMIZER_MODE Initialization Parameter
- Field Parameter的設定
- (轉):學習Oracle動態效能表-(17)-v$parameter & v$system_parameterOracle
- 學習動態效能表第14篇--V$PARAMETER&V$SYSTEM_PARAMETER