今天在pub上看到这个修改oracle静态参数db_writer_processes，自己测试了一下，但是更改此参数在9.2.0.1版本不能生效。不知道为什么？

             

$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期日 10月 8 16:34:08 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

连接到:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

IXDBA.NET社区论坛

With the Partitioning, OLAP and Data Mining options

SQL> show parameter db_writer;

 

NAME                                 TYPE        value

------------------------------------ ----------- ------------------------------

db_writer_processes                  integer     1

SQL> show parameter spfile;

 

NAME                                 TYPE        value

------------------------------------ ----------- ------------------------------

spfile                             string      F:\ORACLE\PRODUCT\10.2.0\DB_1\

                                                 DATABASE\SPFILEORCL.ORA

SQL> alter system set db_writer_processes=2 scope=spfile;

 

系统已更改。

 

SQL> show parameter spfile;

 

NAME                                 TYPE        value

------------------------------------ ----------- ------------------------------

spfile                             string      F:\ORACLE\PRODUCT\10.2.0\DB_1\

                                                 DATABASE\SPFILEORCL.ORA

SQL> show parameter db_writer;

 

NAME