Semaphores Shared memory in Solaris

From: Alessandro Deledda <adeledda_at_it.tiscali.com>
Date: Thu, 4 Oct 2001 10:15:42 +0200
Message-ID: <9ph2f2$kck$1@pegasus.tiscalinet.it>

What is the right semaphores/shared memory settings for a Sun Enterprise cluster E6500 with 2 nodes, 10 logical hosts with 10 Oracle Enterprise Edition 8.1.6 installed and 1 instance for each installation?

RAM 20G
initparameter processes = 400 for each DB SGA for each instance is about 1G;
Sun Solaris 2.6;

Oracle formula says:

Instance A = 100 processes
Instance B = 100 processes
Instance C = 200 precesses

SEMMNS=((A=100) + (B=100)) +((C=200)*2) + ((# of instances)*10)=630; therefore in my case (400*10)+(400*2)+(10*10)=4900 , is it right?

But these instances are concurrently and i have problems with shared memory. shmmax >= SGA?
And if this is right what SGA i have to consider, total SGA of 10 instance (1G*10) or single SGA of each instance (1G)?

This is the result of my calculation but i'm not sure, Do you think it is right?

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=400
set semsys:seminfo_semmsl=400
set semsys:seminfo_semmns=5000
set semsys:seminfo_semopm=400
set semsys:seminfo_semvmx=32767

I am very confused and i hope you help me, thanx in advance. Received on Thu Oct 04 2001 - 03:15:42 CDT