Planning to increase SGA size of Oracle DB, Need suggestion for oracle semaphore settings
Oracle RAC configuration.2 node cluster.
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Physical memory on each node is 16 GB.
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Below parameters are set on each node.
sga_max_size = 2G
sga_target = 1G
pga_aggregate_target
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Current semaphore values on each node are as below.
* ora10g_start
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=200
set semsys:seminfo_semmsl=4000
set semsys:seminfo_semmni=2000
set semsys:seminfo_semmns=2000
set msgsys:msgmax=8192
set msgsys:msgmnb=16384
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Planning to increase sga_target = 5 GB and sga_max_size = 8G
Kindly give us the suggestions on semphore values to be set if we go for above change.
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Physical memory on each node is 16 GB.
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Below parameters are set on each node.
sga_max_size = 2G
sga_target = 1G
pga_aggregate_target
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Current semaphore values on each node are as below.
* ora10g_start
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=200
set semsys:seminfo_semmsl=4000
set semsys:seminfo_semmni=2000
set semsys:seminfo_semmns=2000
set msgsys:msgmax=8192
set msgsys:msgmnb=16384
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Planning to increase sga_target = 5 GB and sga_max_size = 8G
Kindly give us the suggestions on semphore values to be set if we go for above change.
0