Upgrade to Oracle Database 12c — Question 23

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because altering the DB_8K_CACHE_SIZE parameter is allowed dynamically, provided there is sufficient memory available from the autotuned SGA components. Options A and C are incorrect because the parameter can be changed dynamically and the increase can be accommodated within SGA_TARGET. Option D is also incorrect because the increase can fit within SGA_MAX_SIZE.