Oracle 11G OCP 1Z0-053 212

（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部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1263977/，如需轉載，請註明出處，否則將追究法律責任。