ITPub博客

首页 > 应用开发 > IT综合 > Initianization Parameter (3) : DB_CACHE_SIZE

Initianization Parameter (3) : DB_CACHE_SIZE

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

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

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