The number of ORACLE connections (sessions) is related to the number of processes in the parameter file. Their relationships are as follows: & nbsp; sessions (1.1 * process + 5) & nbsp; but when we increase the number of processes, the database may fail to start. This is because a unix system parameter is missing: etcs
The number of ORACLE connections (sessions) is related to the number of processes in the parameter file. Their relationships are as follows:
Sessions = (1.1 * process + 5)
However, when we increase the number of processes, the database often cannot be started. This is because we also missed a unix system parameter: It is semmns in/etc/system/, which is the semaphore parameter of the unix system. Each process occupies a semaphore. After the semmns is adjusted,
You need to restart the unix operating system to make the parameters take effect. However, its size is subject to hardware memory or oracle sga. Range
It can range from 200--2000.
Semmns calculation formula: SEMMNS> processes + instance_processes + system
Processes = database parameter processes value instance_processes = 5 (smon, pmon, dbwr, lgwr, arch)
System = the semaphore occupied by the system. The semaphore occupied by the system can be identified by the following command: # ipcs-sb
The column NSEMS shows that the system has occupied the semaphore.
Other connection-related parameters, such as licence_max_sessions and licence_sessions_warning, are set
Zero, that is, there is no limit. We can use the database with confidence.