高层住宅担架电梯轿厢:oracle 9i内存配置为动态分配的步骤

来源:百度文库 编辑:九乡新闻网 时间:2024/03/29 15:55:08
修改数据库内存动态分配的步骤:
a)         确认目前的内存分配情况
SQL>show sga
         SQL>show parameter db_block_size
            Old parameters that are still active:
         SQL>show parameter db_block_buffers
         SQL>show parameter buffer_pool_keep
         SQL>show parameter buffer_pool_recycle
              New parameters to be set:
         SQL>show parameter sga_max_size
         SQL>show parameter cache_size        SQL>show parameter statistics_level 
b)      确定新的参数设置
Specification of the new parameters
Specification of Keep pool and Recycle pool:
   SQL>show parameter buffer_pool_keep
  SQL>show parameter buffer_pool_recycle
  Set the new parameters the same as the old values, that is:
  db_recycle_cache_size = buffer_pool_recycle
  db_keep_cache_size = buffer_pool_keep
   See note 564861.
   As a rule, these two parameters are not set.
Calculation of sga_max_size:
The following must be established for this parameter:
  •           Current SGA size (lower limit for sga_max_size)
                SQL>show sga
  •            Physical memory of the database server (max. upper limit)