Initianization Parameter (1) : DB_BLOCK_SIZE
Parameter type : Integer
Default value : 8192
Modifiable : No
Range of values : 2048 to 32768, but your operating system may have a narrower range
Basic : Yes
Real Application Clusters : You must set this parameter for every instance, and multiple instances
must have the same value.
DB_BLOCK_SIZE specifies (in bytes) the size of Oracle database blocks. Typical values
are 4096 and 8192. The value of this parameter must be a multiple of the physical
block size at the device level.
The value for DB_BLOCK_SIZE in effect at the time you create the database determines
the size of the blocks. The value must remain set to its initial value.
For Real Application Clusters, this parameter affects the maximum value of the
FREELISTS storage parameter for tables and indexes. Oracle uses one database block
for each freelist group. Decision support system (DSS) and data warehouse database
environments tend to benefit from larger block size values.[@more@]
Default value : 8192
Modifiable : No
Range of values : 2048 to 32768, but your operating system may have a narrower range
Basic : Yes
Real Application Clusters : You must set this parameter for every instance, and multiple instances
must have the same value.
DB_BLOCK_SIZE specifies (in bytes) the size of Oracle database blocks. Typical values
are 4096 and 8192. The value of this parameter must be a multiple of the physical
block size at the device level.
The value for DB_BLOCK_SIZE in effect at the time you create the database determines
the size of the blocks. The value must remain set to its initial value.
For Real Application Clusters, this parameter affects the maximum value of the
FREELISTS storage parameter for tables and indexes. Oracle uses one database block
for each freelist group. Decision support system (DSS) and data warehouse database
environments tend to benefit from larger block size values.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-978022/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Initianization Parameter (5) : THREADthread
- DB_BLOCK_SIZE Initialization Parameter (92)BloC
- Initianization Parameter (4) : CPU_COUNT
- Initianization Parameter (2) : DB_BLOCK_BUFFERSBloC
- Initianization Parameter (3) : DB_CACHE_SIZE
- sqlnet.ora parameter (1)SQL
- oracle的塊 db_block_sizeOracleBloC
- 'MessageBoxA' : function does not take 1 parameterFunction
- DB_BLOCK_SIZE and DB_CACHE_SIZE in OracleBloCOracle
- mybatis Parameter index out of range (1 > number of parameters, which is 0)MyBatisIndex
- Initialization Parameter Files and Server Parameter Files (287)Server
- java.sql.SQLException: No value specified for parameter 1 異常分析JavaSQLException
- Oracle ParameterOracle
- Required parameter $xxx follows optional parameter $yyyUI
- laravel-admin用dingo/api報sha1() expects parameter 1 to be strLaravelGoAPI
- The SPFILE Initialization Parameter
- Sessions & Processes parameterSession
- Import parameter: STATISTICSImport
- Export Parameter : BufferExport
- Export Parameter : QueryExport
- Oracle OCP 1Z0-053 Q450(NLS_* Parameter)Oracle
- 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設定
- 卓的記錄-mysqli_fetch_array() expects parameter 1 to be mysqli_resultMySql
- Oracle OCP 1Z0-053 Q522(NLS_LANGUAGE parameter)Oracle
- 學習動態效能表(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