oracle11 账号密码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

答案解析:

 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> oracle账号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.

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。