How to increase the number of Oracle connections

xiaoxiao2021-03-06  90

Oracle's connections (sessions) are related to the number of processes in its parameter files, and their relationships are as follows: sessions = (1.1 * process 5) But we often start the database when we add Process number. This is because we also miss a UNIX system parameter: it is / etc / system / SemMns, which is the semapic parameter of the UNIX system. Each Process will take up a semaphore. After SemMns is adjusted, you need to restart the UNIX operating system and the parameters can take effect. However, its size will be subject to hardware memory or Oracle SGA. The range can range from 200--2000. The calculation formula of SemMns is: SemMns> Processes Instances = Database Parameters Processes Value INSTANCE_PROCESS = 5 (SMON, PMON, DBWR, LGWR, ARCH) System = The amount of seminars occupied. The amount of signal occupied by the system can be used: #ipcs -sb where the column NSEMS display system has occupied the amount of seminars. Other parameters related to the connection, such as the default settings such as licence_max_sessions, licensions_warning, etc., that is, there is no limit. We can use the database with confidence.

转载请注明原文地址:https://www.9cbs.com/read-125168.html

New Post(0)