Examine the current value 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_SIZE parameter 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_SIZE cannot be accommodated within SGA_TARGET.
D.
It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.