Initianization Parameter (2) : DB_BLOCK_BUFFERS
Parameter type : Integer
Default value : 0
Modifiable : No
Range of values : 50 to an operating system-specific maximum
Basic : No
Real Application Clusters : Multiple instances can have different values, and you can change the
values as needed.
Note: DB_BLOCK_BUFFERS cannot be combined with the dynamic
DB_CACHE_SIZE parameter; combining these parameters in the same
parameter file will produce an error.
DB_BLOCK_BUFFERS specifies the number of database buffers in the buffer cache. It is
one of several parameters that contribute to the total memory requirements of the SGA
of an instance.
This parameter, together with DB_BLOCK_SIZE, determines the total size of the buffer
cache. Effective use of the buffer cache can greatly reduce the I/O load on the
database. DB_BLOCK_SIZE can be specified only when the database is first created, so
you use DB_BLOCK_BUFFERS to control the size of the buffer cache.[@more@]
Default value : 0
Modifiable : No
Range of values : 50 to an operating system-specific maximum
Basic : No
Real Application Clusters : Multiple instances can have different values, and you can change the
values as needed.
Note: DB_BLOCK_BUFFERS cannot be combined with the dynamic
DB_CACHE_SIZE parameter; combining these parameters in the same
parameter file will produce an error.
DB_BLOCK_BUFFERS specifies the number of database buffers in the buffer cache. It is
one of several parameters that contribute to the total memory requirements of the SGA
of an instance.
This parameter, together with DB_BLOCK_SIZE, determines the total size of the buffer
cache. Effective use of the buffer cache can greatly reduce the I/O load on the
database. DB_BLOCK_SIZE can be specified only when the database is first created, so
you use DB_BLOCK_BUFFERS to control the size of the buffer cache.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-978023/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Initianization Parameter (5) : THREADthread
- Initianization Parameter (4) : CPU_COUNT
- Initianization Parameter (1) : DB_BLOCK_SIZEBloC
- Initianization Parameter (3) : DB_CACHE_SIZE
- sqlnet.ora parameter (2)SQL
- Parameter index out of range (3 > number of parameters, which is 2).Index
- Initialization Parameter Files and Server Parameter Files (287)Server
- Oracle ParameterOracle
- oracle 10gR2 dataguard db_unique_name parameterOracle 10g
- Required parameter $xxx follows optional parameter $yyyUI
- Strut2------獲取介面返回的session,application,parameterSessionAPP
- 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
- ORA-29707: inconsistent value 2 for initialization parameter cluster_database_Database
- 使用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