How to modify the number of connections in oracle

Method: 1. Use the "alter system set processes = modify the number of connections scope = spfile" statement to modify the maximum number of connections allowed by the database; 2. After modification, use the "shutdown immediate" and "startup" statements to restart .

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to modify the number of Oracle connections

Step 1: First log in to the database through sqlplus, sqlplus / as sysdba

Step 2: View Number of connections of the current database process

Step 3: Query the number of connections of the current database session

Step 4: View The maximum number of connections and the maximum number of sessions set by the database. The show parameter processes command views the summarized information. You can also directly select value from v$parameter where name ='processes'; to view the statement. The maximum number of process connections is 4000.

Step 5: When the number of database connections needs to be adjusted, you can use alter system set processes = 3000 scope = spfile; to modify the number of connections. (Modifying 3000 is just a demonstration. Most of the time, the number of connections is not enough, and the value is modified larger)

Step 6: Modifying the processes and sessions values ​​must restart the Oracle server to take effect

shutdown immediate; close the instance

startup startup

Step 7: Check again after the step restarts, it has taken effect

Step 8: You can use the following command to check the consumption of database connections: select b.MACHINE, b.PROGRAM, b.USERNAME, count(*) from v$process a, v$session b where a.ADDR = b.PADDR and b.USERNAME is not null

group by b.MACHINE, b.PROGRAM, b.USERNAME order by count(*) desc

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of How to modify the number of connections in oracle. For more information, please follow other related articles on the PHP Chinese website!