Oracle 11G OCP 1Z0-052 116

（116）Your database instance is started using the server  parameter  file  (SPFILE).  

You executed a command 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?

A.The command succeeds only if Automatic Memory Management is not enabled.

B.The command succeeds, but you need to restart the database for changes to take effect.

C.The command returns an error because the size of the redo log buffer cannot be changed dynamically.、

D.The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).

答案：（C）

解析：

sys@TESTDB11>alter system set log_buffer=32M scope=both; alter system set log_buffer=32M scope=both                  * ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1192218/，如需轉載，請註明出處，否則將追究法律責任。