Shared memory settings

[LGJ]

Hi all,

I am looking for some help on setting shared memory settings on our production servers, please see the background below:

Our production server holds a third party billing product. The production server acts as an Oracle client and the DB is held on another server.

On a certain day, billing fails, this is due to the large amount of accounts on this day. We see the high water mark is reached on the search processes on this day causing failure. This is an indication that we needed to increase our memory settings for the searchs, we tried this unsucessfully and got errors relating to shared memory.

We do not have any settings in our /etc/system file though for shared memory. On our development server (which has oracle on it) the settings are as follows:

* Oracle Tunables
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

Will setting the shared memory on our prodcution server to these be ok (cannot find what it is currently at as we have no kernel debugger installed)? I think the default is 8,388,608 for solaris 9.

The settings above are max = 4GB (4294967295). Our production server has 8GB size and our DB server 4GB size. If we dont have enough memory will this 4GB cause any effects or would it just use the max it could?

Any help would be greatly appreciated.

Thanks
LGJ

 

[LGJ]

ttt

Please can anyone help?

Thanks

 

[guggach]

i cannot follow your question, your setting are
really strange, at least shmsys:shminfo_shmmin
is set 3 times.
oracle should be able to say what setting they expect.
here the standard solaris setting:

*set semsys:seminfo_semaem=16384
*set semsys:seminfo_semmap=4154
*set semsys:seminfo_semmni=4186
*set semsys:seminfo_semmns=65675
*set semsys:seminfo_semmnu=2162
*set semsys:seminfo_semmsl=100
*set semsys:seminfo_semopm=100
*set semsys:seminfo_semume=256
*set semsys:seminfo_semvmx=32767
*set shmsys:shminfo_shmmax=67108864
*set shmsys:shminfo_shmmni=4204
*set shmsys:shminfo_shmseg=1068



guggach

 

[guggach]

ignore my typo: at least shmsys:shminfo_shmmin
is set 3 times.

guggach

 

[dbase77]

Hi,

Connect to your sun box and type "sysdef". You should see information regarding your share memory setting. Setting share memory for oracle depends on your system memory and how much you want to allocate for oracle or any other app that use share memory. If you have same specification for both test and live machine I dont see any harm of using test box setting.

dbase77

 

[LGJ]

thanks for the replies guys.

Sorry sysdef command is not found.

Still unsure if I should use the same settings as test box?

As there are no settings currently in /etc/system do you think I could just add:

set shmsys:shminfo_shmmax=4294967295

Thanks

LGJ

 

[dbase77]

Hi,

I must miss your solaris version. Im using solaris 8. Sorry about that. Not sure about solaris 9. My sysdef is under /usr/sbin/ folder. Unless you dont have path set to /usr/sbin .

Yes you can add that to your system file and reboot.

dbase77