oracle 修改 SGA

 

   1. SQL> show sga
　　Total System Global Area 2602007792 bytes
　　Fixed Size 740592 bytes
　　Variable Size 335544320 bytes
　　Database Buffers 2264924160 bytes
　　Redo Buffers 798720 bytes
　　SQL> alter system set sga_max_size=5000m scope=spfile;
　　System altered.
　　SQL> shutdown immediate;
　　SQL> startup
　　SQL> show sga
　　Total System Global Area 5252811728 bytes
　　Fixed Size 744400 bytes
　　Variable Size 2986344448 bytes
　　Database Buffers 2264924160 bytes
　　Redo Buffers 798720 bytes

 

2.出现如下错误：

ORA-00844 Parameter Parameter not taking MEMORY_TARGET into account, see alert log for more...

解决：

 

This is a issue that commonly occurs in that the dba modified the sga_target parameter to a larger

value, but forgot to modify the parameter memory_target (on 11g database) and the rule is that:

                                memory_target >= sga_target + pga_aggregate_target

         and if you have come accross this issue and found your database can not br startup now , don't be

worried, first you should pull out your current parameters using sqlplus :

     解决1步：   SQL> create pfile from spfile;

modify the parameters in the instancename_init.ora as the rule above, then save the file:

   解决2步：     SQL> create spfile from pfile;

then you should be able to startup now:

        SQL> startup;

        ORACLE 例程已经启动。

 

3.我的设置的是 *.memory_target=5242880000

 

 

 

4.windows pfile 文件在oracle_home/database下 linux等平台在在oracle_home/dbs下

数据库装载完毕。
数据库已经打开。