如何修改log_buffer参数

环境:

OS:Windows 2003

DB:10.2.0.1

 

  今天在测试机上试着修改log_buffer参数,发现log_buffer参数值单位不能是K M G,而只能是整数,同时scope不能指定为both,验证过程如下:

1.查看当前的参数值
SQL> show parameters log_buffer;

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_buffer                           integer
7024640

2.scope不能指定为both
SQL> ALTER SYSTEM SET log_buffer = 65536 scope=both;
ALTER SYSTEM SET log_buffer = 65536 scope=both
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

 

3.单位不能是K,M,G
SQL> ALTER SYSTEM SET log_buffer = 32m scope=spfile;
ALTER SYSTEM SET log_buffer = 32m scope=spfile
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> ALTER SYSTEM SET log_buffer = 32k scope=spfile;
ALTER SYSTEM SET log_buffer = 32k scope=spfile
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> ALTER SYSTEM SET log_buffer = 32g scope=spfile;
ALTER SYSTEM SET log_buffer = 32g scope=spfile
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

 

4.不用指定单位,直接就是bytes
SQL> ALTER SYSTEM SET log_buffer = 65536 scope=spfile;

System altered.

5.恢复初始值.
SQL> ALTER SYSTEM SET log_buffer = 7024640 scope=spfile;

System altered.

 

-- The End --