How to modify the maximum number of connections in Oracle

The method to modify the maximum number of Oracle connections is:

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

Step 2: Check the number of connections of the current database process

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

Step 4: Check the maximum number of connections and the maximum number of sessions set by the database. The show parameter processes command checks the summary information. You can also directly select value from v$parameter where name =' processes'; 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 ;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 Tutorial"

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