Examine these parameter settings:SGA_TARGET = 700MSGA_MAX_SIZE = 1024MDB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200MYou attempt this:SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140MWhich statement is true based on the information available?
Question:
Which statement is true based on the information available?
Options:
It will fail because DB_8K_CACHE_SIZE cannot be changed dynamically.
It succeeds only if memory is available from the autotuned components of the SGA.
It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
Correct Answer
The Correct Answer for this Question is
It succeeds only if memory is available from the autotuned components of the SGA.
