In Linux:

Procedure how to increase the SGA in LINUX AS/ES 3.


1. Shutdown the Database.

2. Add following kernel parameter in /boot/grub/grub.conf

Kernel /vmlinuz-2.6.9-34.ELsmp ro root=LABEL=/ rhgb quiet bigpages=6100 MB

Edit and Add following parameter in /etc/sysctl.conf

Kernel.shmmax = 4294967295 (not more then it)

3. Add following parameter in init.ora file:


Sample calculation for 2GB of db_block_buffers

(1024*1024*1024)*2/db_block_size (8192) = 262144


Instead of db_cache_size used following parameter

db_block_buffers=262144
use_indirect_data_buffers=true

4. Restart the Linux server.

5. Up the database and see SGA

SQL> show sga


Total System Global Area 3407418688 bytes
Fixed Size 451904 bytes
Variable Size 1258291200 bytes
Database Buffers 2147483648 bytes
Redo Buffers 1191936 bytes