What would be the outcome of this command?

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?

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?

A.
The command would return an error because LOG_BUFFER is a static parameter.

B.
You need to restart the database so that parameter changes can come into effect.

C.
The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS
is set to value 2.

D.
The parameter value would be changed and it would come into effect immediately.



Leave a Reply 0

Your email address will not be published. Required fields are marked *