ITPub博客

首页 > 应用开发 > IT综合 > Initianization Parameter (2) : DB_BLOCK_BUFFERS

Initianization Parameter (2) : DB_BLOCK_BUFFERS

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-978023/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892256