经常通过更改pfile或者spfile来修改数据库的initital parameter,但是如果我们想要重置呢?那么Oracle给我们提供了reset的选项,但是在alter system 的后面需要加上sid='*'

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn / as sysdba;
已连接。
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE    9.2.0.8.0       Production
TNS for 32-bit Windows: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

SQL> show parameter db_keep_cache_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_keep_cache_size                   big integer 4194304
SQL> alter system reset db_keep_cache_size scope=spfile;
alter system reset db_keep_cache_size scope=spfile
                                                 *
ERROR 位于第 1 行:
ORA-00905: 缺少关键字

SQL> alter system reset db_keep_cache_size scope=spfile sid='*';

系统已更改。

SQL> show parameter db_keep_cache_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_keep_cache_size                   big integer 4194304
SQL> startup force
ORACLE 例程已经启动。

Total System Global Area  139533928 bytes
Fixed Size                   454248 bytes
Variable Size             109051904 bytes
Database Buffers           29360128 bytes
Redo Buffers                 667648 bytes
数据库装载完毕。
数据库已经打开。
SQL> show parameter db_keep_cache_size;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_keep_cache_size                   big integer 0
SQL>