Modify the oracle of the SGA size
Posted on 2009-11-06 filed under: Oracle (RSS) 13 views
2, shutdown, unplug the power supply and a variety of connection lines, out of chassis, open chassis cover to increase the memory;
3 After completion, as is the resumption of the various components and connectors is good, electric start, the system to normal operation;
4, into the system look and found the memory has been successfully installed;
5, modify the database SGA parameters:
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, inspection systems and databases completely correct, the backup system
Tags: oracle, parameters, backup database, databases, memory, max size, global area, variable size, scope, resumption, database 2, sga size, backup system, chassis, power supply
Permalink: http://www.kods.net/modify-the-oracle-of-the-sga-size/