How many Semaphores needed?
For Oracle Enterprise Server 220.127.116.11
We are working on getting a new HP-UX 11i (64-bit) server and need to know the semaphore requirements for the unix group.
As per Oracle's recommendation for each instance -
Semaphores = ((value of processes in init file)*2) + a few for Oracle's internal use.
My questions are -
# is the equation same for 64-bit OS (and database)?
Is this a good estimate depending upon if I estimated my processes correctly for all the instances?
# Does this number change with Oracle 9i?
I'd suggest these values for HP/UX 11i (64-bit). We have used the same values on HP/UX 10.2 (32-bit) on 7.x, 8.x, and 9.x without problems.
SEMMAP (SEMMNI + 2)
SEMMNS (SEMMNI * 2)
SEMMNU (NPROC - 4)
SHMMAX Available physical memory
Here's a few that have bit us in the past:
NFILE (15 * NPROC + 2048)
You didn't ask for it, but .. Best of luck .. on your migration to Linux. (just poking fun)
Click Here to Expand Forum to Full Width