db_block_size :标准块大小,默认8k。
db_cache_size : 标准块存放的内存空间大小,SGA自动管理时此参数不用设置。
db_nk_cache_size: 指定非标准快大小内存空间,比如2k,4k,16k,32k
db_keep_cache_size : keep 存放经常访问的小表或索引等。
db_recycle_cache_size : 与keep相反,存放偶尔做全表扫描的大表的数据。
idle>show parameter block;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_file_multiblock_read_count integer 43
idle>
idle>
idle>
idle>show parameter cache;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_advice string ON
db_cache_size big integer 0
db_flash_cache_file string
db_flash_cache_size big integer 0
db_keep_cache_size big integer 12M
db_recycle_cache_size big integer 0
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
result_cache_max_result integer 5
result_cache_max_size big integer 1M
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
session_cached_cursors integer 50
idle>