如何修改db_block_buffers

SQL> show parameter db_block_buffers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers                     integer     0
SQL> alter system set db_block_buffers=300 scope=spfile;

系统已更改。

SQL> show parameter db_block_buffers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_block_buffers                     integer     0
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORA-00381: cannot use both new and old parameters for buffer cache size specification
SQL>
SQL> create pfile from spfile;

文件已创建。

在os下边修改INIToic.ORA删除*.db_block_buffers=300

SQL> startup pfile=D:/oracle/ora92/database/INIToic.ORA;
ORACLE 例程已经启动。

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
数据库装载完毕。
数据库已经打开。
SQL> create spfile from pfile;

文件已创建。 

db_block_buffers is deprecated in 9i. The new parameter is db_cache_size.

You have encountered a bug wherein oracle allows you to set both the parameters .. however, database will not come up because both of them cannot be defined.

To fix this:

export your spfile to a pfile:

create pfile from spfile;

Fix the problem by removing the entry for db_block_buffers.

and then recreate spfile by:

create spfile from pfile;