Concept内容的翻译_1024(英语水平差,发出来主要是想让大家帮我指正一下,谢谢!)

The DB_nK_CACHE_SIZE parameters cannot be used to size the cache for the standard
block size. If the value of DB_BLOCK_SIZE is nK, it is illegal to set DB_nK_CACHE_SIZE.
The size of the cache for the standard block size is always determined from the value
of DB_CACHE_SIZE.

DB_nK_CACHE_SIZE 参数,不能用于决定标准块大小的块的CACHE大小,如果
DB_BLOCK_SIZE的值为nK,那么设置DB_nK_CACHE_SIZE参数是违法的,标准块
大小的块的CACHE大小总是取决于DB_CACHE_SIZE。


The cache has a limited size, so not all the data on disk can fit in the cache. When the
 cache is full, subsequent cache misses cause Oracle to write dirty data already in the
 cache to disk to make room for the new data. (If a buffer is not dirty, it does not
 need to be written to disk before a new block can be read into the buffer.)
 Subsequent access to any data that was written to disk results in additional
 cache misses.
 
 
 CACHE的大小是有限的,所以不是所有磁盘上的数据都可以装配到cache,当cache
 满时,后来cache失效引起oralce写脏cache中已有的脏数据到磁盘,为新的数据腾
 出空 间。(如果没有脏数据,在新的块读入buffer前不需要写入磁盘)。以后对任何已
 经写入磁盘的数据的访问导致另外的cache失效(不能命中)。
 
 
 The size of the cache affects the likelihood that a request for data results in a cache hit.
  If the cache is large, it is more likely to contain the data that is requested. Increasing
  the size of a cache increases the percentage of data requests that result in cache hits.
 
  cache 的大小会可能影响一次数据请求的cache命中,如果cache非常大,就可以包含
  更多的数据被请求的数据。增大cache的大小,可以增加数据请求的cache命中百
  分比(命中率)。
 
 
  You can change the size of the buffer cache while the instance is running, without
   having to shut down the database. Do this with the ALTER SYSTEM statement.
   For more information, see "Control of the SGA's Use of Memory".
  
   你可以在实例运行时改变buffer cache的大小,不用shutdown数据库,利用
   ALTER SYSTEM 语句来实现。更多的信息,查看:Control of the SGA's Use
   of Memory
  
  
   Use the fixed view V$BUFFER_POOL to track the sizes of the different cache
   components and any pending resize operations.
  
   可以用 V$BUFFER_POOL跟踪不同cache组成部分的大小和未决的大小调整操作。 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值