![]() The value of SEMMNS is calculated as follows: For example, consider a system that has three Oracle instances with the PROCESSES parameter in their initsid.ora files set to the following values: Set to the sum of the PROCESSES parameter for each Oracle database the largest one, plus 2 times the largest PROCESSES value, plus 10 number of Oracle databases. The default value of PROCESSES for the 8.1.5 prebuilt database is 50. The PROCESSES parameter can be found in each initsid.ora file, loc ORACLE_HOME/dbs directory. Set to 10 plus the largest initsid.ora PROCESSES parameter of an Oracle database on the system. (The PROCESSES parameter in the init.ora file). SEMMSL = The maximum number of sempahores that can be in one SEMMNI = The number of semaphore set identifiers in the system ĭetermines the number of semaphore sets that can be SEMMNS = The number of semaphores in the system. The above settings should also be sufficient. SHMSEG = The maximum number of shared memory segments that can SHMMNI = The number of shared memory identifiers. They are sufficient for pretty much all systems. The above settings let the max be bigger then we wil ever use and the min much smaller. SHMMIN = The minimum size(in bytes) of a single shared memory SHMMAX = The maximum size(in bytes) of a single shared memory
0 Comments
Leave a Reply. |