Oracle Database 12c: Installation and Administration — Question 205

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32 M;
What is the outcome of this command?

Answer options

• A. The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.
• B. It returns an error because the value of this parameter cannot be changed dynamically.
• C. The parameter value is changed and it comes into effect at the next instance startup.
• D. It returns an error because SCOPE should be set to MEMORY.

Correct answer: B

Explanation

The correct answer is B because the LOG_BUFFER initialization parameter cannot be changed dynamically when using an SPFILE; it requires a database restart to take effect. Options A and C are incorrect as they imply dynamic changes are possible, while option D is wrong because the error does not pertain to the SCOPE parameter.