How to view the current number of connections in Oracle

The following articles will teach you how to view the current number of connections in Oracle and how to view the current number of connections in Oracle databases? We only need to use the following SQL statements for query. The following describes the specific content of the article.

 
 

  
  
select * from v$session where username is not null  
  
  
select username,count(username) from v$session where 
username is not null group by username  
 
 

View the number of connections of different users

 
 

  
  
select count(*) from v$session 
 
 

Connections

 
 

  
  
Select count(*) from v$session where status='ACTIVE' 
 
 

Concurrent connections

 
 

  
  
show parameter processes  
 
 

Max connection

 
 

  
  
alter system set processes = value scope = spfile; 
 
 

Restart the database to modify the connection

 
 

  
  
/home/Oracle9i/app/Oracle9i/dbs/init.ora  
  
  
/home/Oracle9i/app/Oracle9i/dbs/spfilexxx.ora  open_cursor   
 
 

The above content describes how to view the current number of connections in Oracle, hoping to help you in this regard.