Home » RDBMS Server » Server Administration » how to calculate semaphore parameters
how to calculate semaphore parameters [message #62663] Sun, 08 August 2004 04:49 Go to next message
Kapil
Messages: 145
Registered: May 2002
Senior Member
Can I install Oracle 9204 Server on 485 MB RAM, Swap 988 MB, 15 GB HDD machine with Linux Red Hat 8 OS?

If I can install then what should be my following parameters? And how to evaluate those parameters and what values I should set in my case?

 

<OL style="MARGIN-TOP: 0in" type=1>
<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in">Semaphore parameters SEMMSL, SEMMNS, SEMOPM, SEMMNI

<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in">Shared memory parameters SHMMAX, SHMMIN, SHMMNI, SHMSEG


<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in">File handle


<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in">Sockets


<LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in">Process Limit

</OL>

What I will have on my Sever? This is a personal PC, it's for testing some features and learning, so it is neither oltp nor dss

<SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Appreciate your help

Thank you
Re: how to calculate semaphore parameters [message #62687 is a reply to message #62663] Mon, 09 August 2004 11:02 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
If you have toad, try:
DBA > OS Utilities > Unix kernel params.

Mine reports this for (1 database, 50 sessions max, 1 degree of parallelism):
Linux steps:
===========
1. Edit /usr/src/linux-2.4/include/linux/shm.h
2. Edit /usr/src/linux-2.4/include/linux/sem.h
3. Compile new kernel (i.e. make dep clean bzImage)
4. Copy new kernels vmlinuz and system.map to /boot
5. Add the new kernel to lilo or grub boot loader
6. Reboot the machine

/usr/src/linux-2.4/include/linux/shm.h modifications
====================================================
SHMMAX=0x40100000
SHMMIN=1
SHMMNI=100
SHMSEG=10

/usr/src/linux-2.4/include/linux/sem.h modifications
====================================================
SEMMNI=100
SEMMSL=60
SEMMNS=(SEMMNI*SEMMSL)
SEMOPM=100
SEMVMX=32767
Previous Topic: Number size?
Next Topic: accidental creation of tables in system tablespace
Goto Forum:
  


Current Time: Fri Sep 27 10:32:15 CDT 2024