首页 > 应用开发 > IT综合 > Initianization Parameter (1) : DB_BLOCK_SIZE

Initianization Parameter (1) : DB_BLOCK_SIZE

原创 IT综合 作者:tsinglee 时间:2007-10-22 10:20:39 0 删除 编辑
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@]

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量