[Oracle OCP 052-1-1] database buffer相关参数

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>