修改数据库的启动参数,内存设置

1732阅读 0评论2009-03-03 lukeunique
分类:Oracle

$ cd $ORACLE_HOME
$ cd dbs
$ sqlplus /nolog
SQL> conn /as sysdba
Connected.
SQL> create pfile from spfile;
File created.
SQL> host
$ vi initSID.ora
 
 
:wq
$ exit;
SQL> shutdown immediate;
SQL> startup pfile=$ORACLE_HOME/dbs/initgaudi02.ora
SQL> create spfile from pfile;
SQL> select * from v$sga;
SQL> show sga
$ vmstat -s -S m
上一篇:2009.02.21_17_24 InstanceandMediaRecoveryStructu
下一篇:Library、Latch、Buffer三大关键指标的命中率