Home > Database > Oracle > body text

How to modify the maximum number of connections in Oracle

hzc
Release: 2020-06-09 13:49:20
Original
9804 people have browsed it

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

How to modify the maximum number of connections in Oracle

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

How to modify the maximum number of connections in Oracle

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

How to modify the maximum number of connections in Oracle

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.

How to modify the maximum number of connections in Oracle

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)

How to modify the maximum number of connections in Oracle

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

shutdown immediate; close the instance

startup startup

How to modify the maximum number of connections in Oracle

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

How to modify the maximum number of connections in Oracle

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

How to modify the maximum number of connections in Oracle

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template