632.Note the following parameter settings: 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
验证:
SQL> show parameter db
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
clonedb boolean FALSE
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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 0
db_create_file_dest string
SQL> ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
System altered.
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size
因8K是标准的block size,所以参数db_8k_cache_size不能被修改
![](http://img.blog.itpub.net/blog/attachment/201603/30/8520577_1459307631DdTZ.png?x-oss-process=style/bb)
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
验证:
SQL> show parameter db
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
clonedb boolean FALSE
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
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 0
db_create_file_dest string
SQL> ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
System altered.
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size
因8K是标准的block size,所以参数db_8k_cache_size不能被修改
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-2072243/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8520577/viewspace-2072243/