OCP-1Z0-053-V13.02-632题

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.