-
How many Semaphores needed?
For Oracle Enterprise Server 8.1.7.4
====================================
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?
Thanks,
- Rajeev
Rajeev Suri
-
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)
SEMMNI 4096
SEMMNS (SEMMNI * 2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX Available physical memory
SHMMNI 512
SHMSEG 32
Here's a few that have bit us in the past:
NPROC 4000
MAXUPRC ((NPROC*9)/10)
NFILE (15 * NPROC + 2048)
NFLOCKS 4096
You didn't ask for it, but .. Best of luck .. on your migration to Linux. (just poking fun)
-Ken
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|