[url]http://oracle.chinaitlab.com/optimize/823672.html[/url]
[b]修改oracle的SGA区大小 [/b]
1、备份数据库;
2、关机,拔下电源和各种连接线,抽出机箱,打开机箱上盖,增加内存;
3、完成后按原样将各个部件及连接线恢复好,电开机,系统正常运行;
4、进入系统查看,发现内存已经顺利安装;
5、修改数据库SGA参数:
show parameter SGA;
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
6、检查系统和数据库完全无误后,备份系统
[url]http://www.ixdba.net/article/45/2014.html[/url]ORACLE SGA_MAX_SIZE与SGA_TARGET
[url]http://www.itpub.net/thread-931173-2-1.html[/url]alter system flush shared_pool
[url]http://www.examda.com/oracle/zhonghe/20090406/094519661.html[/url]Oracle性能调优:详解Oracle几种性能调优方法
[b]修改oracle的SGA区大小 [/b]
1、备份数据库;
2、关机,拔下电源和各种连接线,抽出机箱,打开机箱上盖,增加内存;
3、完成后按原样将各个部件及连接线恢复好,电开机,系统正常运行;
4、进入系统查看,发现内存已经顺利安装;
5、修改数据库SGA参数:
show parameter SGA;
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
6、检查系统和数据库完全无误后,备份系统
[url]http://www.ixdba.net/article/45/2014.html[/url]ORACLE SGA_MAX_SIZE与SGA_TARGET
[url]http://www.itpub.net/thread-931173-2-1.html[/url]alter system flush shared_pool
[url]http://www.examda.com/oracle/zhonghe/20090406/094519661.html[/url]Oracle性能调优:详解Oracle几种性能调优方法