OS: 5.10
DB Version: 11.2.0.4
we have 3 instances running on the server
instanceA SGA_target: 10G
instanceB SGA_target: 8G
instanceC SGA_target: 7G
Total current SGA for all 3 instance = 25GB
Total physical memory: 60GB
projects allocated to oracle: 30GB max shared memory
project.max-shm-memory=(priv,32212254720,deny)
I tried to increase the SGA_TARGET for instanceC from 7GB to 14GB and I got out of memory issue(ORA-27102: out of memory) while instance startup.
could you please tell me if the project.max-shm-memory=30g is the total shared memory for oracle user, so the sum of sga for instanceA+ instanceB+instanceC should not exceed 30G?