How to set Oracle to use more than 4GB of SGA

[sillyVM]

My ubuntu linux server x64 has 8GB of RAM. I would like to allocate 5GB to SGA.

here's what i add in my /etc/sysctl.conf

fs.file-max = 65535
kernel.shmall = 2097152
kernel.shmmax = 6442450944 (this is set to 6g)
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

But it will not let me allocate 5GB to SGA. Anyone know what should i do to make it work? Thanks

 

[sillyVM]

Okay I change the following settings to

orcl.__db_cache_size=1795162112
orcl.__java_pool_size=16777216
orcl.__large_pool_size=16777216
orcl.__shared_pool_size=301989888
orcl.__streams_pool_size=0

Original is

orcl.__db_cache_size=50331648
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=100663296
orcl.__streams_pool_size=0

My total system memory is 8GB, oracle SGA can use 6GB, PGA 700MB Thanks

 

[sillyVM]

of course oracle and os are 64bits.

 

[bjverzal]

I'll also add to check "/etc/security/limits.conf "

BV

 

[sillyVM]

* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536

I had these when I installed oracle, should be okay right?

 

[bjverzal]

(oracle@<hostname>) /opt/oracle > ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 128000
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited

BV

 

[sillyVM]

asentinel@rom-linux1:~$ ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 20
file size (blocks, -f) unlimited
pending signals (-i) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) unlimited
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 2047
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited


What does this tell you?

 

[bjverzal]

Looks like it will work fine.