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
解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams133.htm#REFRN10094
LOG_BUFFER:redo写入从内存写入redo文件的这块区域,以字节为单位,并且是静态参数,不可以动态修改
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;这里其实有两个错误,第一是32M,第二是SCOPE=BOTH
scope=both相当于scope=spfile和scope=memory的总和,也就是配置文件和内存同时进行修改
SQL> alter system set log_buffer=2240512 scope=both;
alter system set log_buffer=2240512 scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set log_buffer=2m scope=spfile;
alter system set log_buffer=2m scope=spfile
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set log_buffer=2240512 scope=spfile;
System altered.
--这样就可以了
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
解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams133.htm#REFRN10094
LOG_BUFFER:redo写入从内存写入redo文件的这块区域,以字节为单位,并且是静态参数,不可以动态修改
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;这里其实有两个错误,第一是32M,第二是SCOPE=BOTH
scope=both相当于scope=spfile和scope=memory的总和,也就是配置文件和内存同时进行修改
SQL> alter system set log_buffer=2240512 scope=both;
alter system set log_buffer=2240512 scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set log_buffer=2m scope=spfile;
alter system set log_buffer=2m scope=spfile
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set log_buffer=2240512 scope=spfile;
System altered.
--这样就可以了