修改数据库内存动态分配的步骤:
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)