Modify the anatomy of Oracle SGA

Today we are going to discuss with you how to modify the size of the Oracle SGA zone. I saw the actual application materials for modifying the size of the Oracle SGA zone on the relevant website two days ago, let's share it with you. The following describes the content of the text.

1. Back up the database;

2. Shut down, unplug the power supply and various connection lines, extract the chassis, open the chassis, and increase the memory;

3. After the installation is completed, all components and connection lines are restored as they are, and the system is running normally;

4. Go to the system and check that the memory has been successfully installed;

5. Modify the database Oracle 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 sgaTotal System Global Area 5252811728 bytes  
  
  
Fixed Size 744400 bytes  
  
  
Variable Size 2986344448 bytes  
  
  
Database Buffers 2264924160 bytes  
  
  
Redo Buffers 798720 bytes  
 
 

6. Back up the system after checking that the system and database are completely correct

The above content is a description of the actual operation steps for modifying the size of the Oracle SGA area. I hope it will help you in this regard.