How to Configure RHEL AS4 64-bit for Large SGA up to 10GB with a system RAM at 32 GB?
when I first started I thought it is easy way to follow the tradition like: set init.ora sga_max size parameter, rebounce DB. However, it gives Linux OS error with 'out of mem'/'not enough mem'
it is related to linux memory setttings (shmmax|shmmni|shmall), and SGA 'mapped_base address' during I dig out related articles.
Our system:
OS: Linux x86_64bit, AS 4.0
Kernel: 2.6.9-55.ELlargesmp
DB: 10.2.0.3
$ cat /proc/sys/kernel/shmmax
8589934592
$ $ cat /proc/sys/kernel/shmmni
4096
$ cat /proc/sys/kernel/shmall
3279547
$ ipcs -lm
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 8388608