Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
- AThe command succeeds only if Automatic Memory Management is not enabled.
- BThe command succeeds, but you need to restart the database for changes to take effect.
- CThe command returns an error because the size of the redo log buffer cannot be changed dynamically.
- DThe parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).