Database Administration (MOSC)

MOSC Banner

Planning to increase SGA size of Oracle DB, Need suggestion for oracle semaphore settings

edited Sep 30, 2011 8:37AM in Database Administration (MOSC) 3 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center