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