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
答案解析:
根据db_block_size=8192可知,该数据库的标准块是8k,且不能改变标准块的大小。
sys@TEST1107> 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
sys@TEST1107> ALTER SYSTEM SET DB_CACHE_SIZE=50M;
System altered.
sys@TEST1107> ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
System altered.
sys@TEST1107> ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
System altered.