How to increase the number of Oracle connections

xiaoxiao2021-03-06  38

How to increase the number of Oracle connections

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 Parameter Processes value instance_processes = 5 (SMON, PMON system = system occupying the number of semaphors, the number of semaphors occupied by the system): #ipcs -sb 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, license_sessions_warning, etc., there is no limit. We can use the database with confidence. I hope this article can be a beginner it works.

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

New Post(0)