• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Question    
What are the steps in increasing the Oracle SGA memory allocation?

Answer    
[Note the following steps should be performed by the Database administrator.  The following presumes that there’s extra memory which can be used for this purpose.   Otherwise, more memory may need to be added.] 
1. Assuming this is a Linux box, make sure /dev/shm has more than 11520 MB* available space. If not increase it, otherwise the DB will fail to start. (Note: "11520 MB" is just an example. This will vary from machine to machine.) 
2. Backup the existing parameter file by creating a pfile (assuming an spfile is used). 
3. on the DB server, login as sysdba: 
  su - oracle 
  sqlplus / as sysdba 
  alter system set memory_max_target=11520m scope=spfile; --assuming an spfile is used 
  alter system set memory_target=11520m scope=spfile; --assuming an spfile is used 
4. shutdown the DB 
5. start the DB

Additional Info / Related Articles    

The following article discusses the possible need for an increase in SGA with Aleph 22/Oracle 11r2:
"Multi-process, I/O intensive jobs slow in Aleph 22/Oracle 11r2"

Do the following to see your SGA value:

  > sqlplus ALEPH_ADMIN/ALEPH_ADMIN

  aleph_admin@LIBP> show sga

• Article last edited: 27-Mar-2016