（212）Note the following parameters settings in your database:

SGA_MAX_SIZE=1024M

SGA_TARGET=700M

DB_8K_CACHE_SIZE=124M

LOG_BUFFER=200M

You issued the following command to increase the value of DB_8K_CACHE_SIZE:

SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

What would happen?

A.It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically

B.It will be successful only if the memory is available from the auto tuned components

C.It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET

D.It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated with in SGA_MAX_SIZE

答案：（D）

解析：

DB_8K_CACHE_SIZE不属于SGA_TARGET自动管理。

SGA_TARGET自动管理的是DB_CACHE_SIZE

LOG_BUFFER也不属于SGA_TARGET自动管理。

SGA_MAX_SIZE-SGA_TARGET-LOG_BUFFER=1024-700-200= 124M < 140M，所以，会报超过SGA_MAX_SIZE的上限

ITPub博客

Oracle 11G OCP 1Z0-053 212