Hi, we wanted to utilize the maximum allowable memory for our machine with 750gb of RAM.
The OS we are running is OEL6 64bit with RAC 11.2.0.4.
I remember configuring the memory limit during DBCA to 310,085 GB
from the saved response file:
#-------------------------------------------------------------------------------
# Specify the total memory allocation for the database. Value(in MB) should be
# at least 256 MB, and should not exceed the total physical memory available
# on the system.
# Example: oracle.install.db.config.starterdb.memoryLimit=512
#-------------------------------------------------------------------------------
oracle.install.db.config.starterdb.memoryLimit=310085
but after installation the parameter file has this value:
pga_aggregate_target big integer 321764M
sga_max_size big integer 64G
sga_target big integer 64G
How do i increase the SGA/PGA settings to use the maximum that can be used?
/etc/sysctl.conf has these values:
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
vm.swappiness = 0
vm.dirty_background_ratio = 3
vm.dirty_ratio = 80
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 100
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
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
Thanks.