【Oracle】修改oracle中SGA区的大小
1、备份数据库;
2、关机,拔下电源和各种连接线,抽出机箱,打开机箱上盖,增加内存;
3、完成后按原样将各个部件及连接线恢复好,电开机,系统正常运行;
4、进入系统查看,发现内存已经顺利安装;
5、修改数据库SGA参数:
SQL> show sga
Total System Global Area 2602007792 bytes
Fixed Size 740592 bytes
Variable Size 335544320 bytes
Database Buffers 2264924160 bytes
Total System Global Area 5252811728 bytes
Fixed Size 744400 bytes
Variable Size 2986344448 bytes
2、关机,拔下电源和各种连接线,抽出机箱,打开机箱上盖,增加内存;
3、完成后按原样将各个部件及连接线恢复好,电开机,系统正常运行;
4、进入系统查看,发现内存已经顺利安装;
5、修改数据库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
System altered
SQL> shutdown immediate;
SQL> startup
Total System Global Area 5252811728 bytes
Fixed Size 744400 bytes
Variable Size 2986344448 bytes
Database Buffers 2264924160 bytes
Redo Buffers 798720 bytes
6、检查系统和数据库完全无误后,备份系统
只有学习才能跟上时代的脚步