QUESTION 32
Examine the current values for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?
A. It fails because the DB_8K_CACHE_SIZEparameter cannot be changed dynamically.
B. It succeeds only if memory is available from the autotuned components if SGA.
C. It fails because an increase in DB_8K_CACHE_SIZEcannot be accommodated within SGA_TARGET.
D. It fails because an increase in DB_8K_CACHE_SIZEcannot be accommodated within
SGA_MAX_SIZE.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
“DB_nK_CACHE_SIZE”参数的取值有很多种,有2k、4k、8k、16k、32k。在设置此参数时,我们需要注意的是,与数据库默认的块尺寸相同的那个参数是不能被设定的。例如,如果数据库的默认块尺寸是8k,那么当我们尝试设置“DB_8K_CACHE_SIZE”参数时便会遭遇报错(报错内容:ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size)。这是由于这个信息已经体现在“db_cache_size”参数上。
这里给出具体直观的体验过程。
问题32
检查数据库实例中下列参数的当前值:
SGA_MAX_SIZE = 1024
SGA_TARGET = 700
DB_8K_CACHE_SIZE = 124
LOG_BUFFER = 200
执行以下命令增加DB_8K_CACHE_SIZE的值:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
哪一种说法是正确的?
A.它失败是因为DB_8K_CACHE_SIZEparameter不能动态更改。
B.如果SGA,它只有在自调整组件的内存可用时才会成功。
C.它失败是因为在SGA_TARGET中不能容纳db_8k_cache_size的增加。
D.它失败是因为db_8k_cache_size不能被容纳
SGA_MAX_SIZE。
正确答案是:B
部分:(一)
解释
解释/参考: