[20121207]实例与参数设置.txt

SQL> select * from v$version where rownum<=1;


BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production


SQL> show parameter 32k


NAME                                 TYPE        VALUE

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

db_32k_cache_size                    big integer 0


SQL> host echo $ORACLE_SID

test


SQL> alter system set db_32k_cache_size=64M scope=spfile;

System altered.


$ strings spfiletest.ora| grep  32k

*.db_32k_cache_size=67108864


SQL> alter system set db_32k_cache_size=64M scope=spfile sid='test1';

System altered.


SQL> alter system set db_32k_cache_size=64M scope=spfile sid='xxx';

System altered.


$ strings spfiletest.ora| grep  32k

*.db_32k_cache_size=67108864

test1.db_32k_cache_size=67108864

xxx.db_32k_cache_size=67108864

--可以发现，我们可以建立任何实例的参数。

--删除不需要的参数:
SQL> alter system reset db_32k_cache_size sid='*';
System altered.

$ strings spfiletest.ora| grep 32k
test1.db_32k_cache_size=67108864
xxx.db_32k_cache_size=67108864
--sid='*'参数并不删除其他实例的参数。

SQL> alter system reset db_32k_cache_size  sid='*';

alter system reset db_32k_cache_size  sid='*'

ERROR at line 1:

ORA-32010: cannot find entry to delete in SPFILE

SQL> alter system reset db_32k_cache_size  sid='xxx';

System altered.


SQL> alter system reset db_32k_cache_size  sid='test1';

System altered.

ITPub博客

[20121207]实例与参数设置.txt

最新文章