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的上限