记录一个Oracle BUG

Oracle版本：9.2.0.1

OS：Solaris8

问题描述：修改db_writer_processes参数无效

SQL> show parameter db_write

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
db_writer_processes                  integer                          1

 

 

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

System altered.

Elapsed: 00:00:00.08
idle> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
idle> startup
ORACLE instance started.

Total System Global Area  322929752 bytes
Fixed Size                   730200 bytes
Variable Size             201326592 bytes
Database Buffers          117440512 bytes
Redo Buffers                3432448 bytes
Database mounted.
Database opened.
idle> show parameter db_write

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
db_writer_processes                  integer                          1

 

查看alter.log文件发现这个参数还是1：

... ...

 db_block_size            = 8192
  db_writer_processes      = 1
  db_cache_size            = 117440512
  db_cache_advice          = OFF
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE

... ...

查看spfile文件：

... ...

*.db_block_size=8192
*.db_cache_advice='OFF'
*.db_cache_size=104857600
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='DBAP01'
*.db_writer_processes=2
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DBAP01XDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE

... ...

发现在这里记录的参数值是2，表示参数修改成了。

SQL> show parameter spfile

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
spfile                               string                           ?/dbs/spfile@.ora
idle>

数据库使用spfile文件启动的！

解决办法，升级数据库到9.2.0.5解决问题