This discussion is archived
1 Reply Latest reply: Feb 14, 2013 12:17 AM by Helios-GunesEROL RSS

SGA size can not be greater than maximum shared memory segment size

okKarol Newbie
Currently Being Moderated
Hello Dear's

I've this issue which is not quite logical ,
Platform:
Linux UBUNTU 12.4
Oracle 11g2

Kernel Parameters from sysctl

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
#kernel.shmmax = 536870912
kernel.shmmax = 2147483648 >>>>> I put the Max Value
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

BUT:
When Creating a Database using DBCA when choosing the Memory Type (AMM) or custom (Manually Shared Memory management) ... If I choose to configure Manually,
I define the following Values:
SGA 8Gb,
BuFFER Cache = 4Gb

Just this values are enough to get that warning message "SGA size can not be greater than maximum shared memory segment size"
But If instead, I configure 32Gb using AMM Type it dosn't give me any warning !!!!!
Which makes me think ... something is wrong
Any Help ?
Thxs in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points