Chapter 8. Setting Semaphores
8.1. The SEMMSL Parameter
PROCESSESis very large, then SEMMSL should be larger as well. Note what Metalink Note:187405.1 and Note:184821.1 have to say regarding SEMMSL: "The SEMMSL setting should be 10 plus the largest
PROCESSESparameter of any Oracle database on the system". Even though these notes talk about 9i databases this SEMMSL rule also applies to 10g databases. I have seen low SEMMSL settings to be an issue for 10g RAC databases where Oracle recommended to increase SEMMSL and to calculate it according to the rule mentioned in these notes. An example for setting semaphores for higher
PROCESSESsettings can be found at Section 8.6, “An Example of Semaphore Settings”.