Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to Increase SGA Size

Nano_4612219Dec 7 2011 — edited Dec 7 2011

Hi,

RDBMS : 11.1.0.7.0
OS : RHEL 5 (X86_64)
EBS : 12.1.3

My Database Server RAM size is 128 gb

Currently my Parameters are

SGA_Target = 2g
SGA_max = 2g
Shared_pool_size = 600m

Kernel Parameters are :

kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.sem = 256 32000 100 142
kernel.shmmni = 4096
kernel.msgmni = 2878
fs.file-max = 6553600
net.ipv4.ip_local_port_range = 1000 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

My question is...

As My project manager is asking to increase the SGA Size as i have 128gb RAM of server.

Maximum how much i can increase the SGA Size

It is PRODUCTION Server... Now it's running with out any issue... but so much RAM is there y can't we use....?

Please advice..

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2012

Added on Dec 7 2011

#general-database-discussions

7 comments

1,555 views