修改數據庫內存動態分配的步驟:
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)