Examine the current values for the following parameters in your database instance:SGA_MAX_SIZE = 1024M -SGA_TARGET = 700
Posted: Sun Jun 11, 2023 3:50 pm
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_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.
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.