# Current limits cat /proc/sys/kernel/shmmax cat /proc/sys/kernel/shmall Set for large SGA:
# Current semaphore limits (SEMMSL, SEMMNS, SEMOPM, SEMMNI) ipcs -ls | grep "max number of arrays" cat /proc/sys/kernel/sem Recommended for Oracle:
SELECT value/1024/1024 MB FROM v$parameter WHERE name='sga_max_size'; Check free memory :
ipcs -s | grep oracle | awk 'print $2' | xargs -n1 ipcrm -s Linux :
vi /etc/security/limits.conf Add: