Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command?()
- AThe command would return an error because LOG_BUFFER is a static parameter.
- BThe parameter value would be changed and it would come into effect immediately.
- CYou need to restart the database so that parameter changes can come into effect.
- DThe command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.