QUESTION 55
Note the following parameter settings:
SQL> show parameter DB
NAME TYPE VALUE
----------------- ----------- -------
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_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
Which setting is NOT allowed?
A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
Answer: B
同632题:http://blog.csdn.net/rlhua/article/details/17259435
Explanation/Reference:
Section: Initialization, Parameters, File Location & Server Configuration
http://www.akadia.com/services/ora_asm_multiple_block_sizes.html
db_block_sizeinteger 8192 - is the db default so you can't have8K subcache
本文探讨了Oracle数据库中与缓存相关的参数设置问题,特别是不允许设置的db_8k_cache_size参数,并解释了原因。同时提供了相关链接进一步阐述不同缓存大小参数的作用。
7978

被折叠的 条评论
为什么被折叠?



