Steps for modifying the maximum number of connections in Oracle

The following article describes how to modify the maximum number of connections in Oracle, including the correct method for modifying the maximum number of connections related to Oracle and how to query the usage of Oracle cursors, the following describes the main content of the text.

1. How to modify the maximum number of connections in Oracle

A. log on to PL/SQL or Worksheet as sysdba

B. query the current number of connections

 
 

  
  
show parameter processes; 
 
 

C. Change the number of system connections

 
 

  
  
alter system set processes=1000 scope=spfile; 
 
 

D. Create a pfile.

 
 

  
  
create pfile from spfile; 
 
 

E. Restart the Oracle service or the Oracle server

2. How to query Oracle cursor usage

 
 

  
  
select * from v$open_cursor where user_name = 'TRAFFIC'; 
 
 

3. query Oracle sessions

 
 

  
  
select * from v$session 
 
 

 

The above content describes how to modify the maximum number of connections in Oracle. I hope it will help you in this regard.

Article by: http://www.programbbs.com/doc/3316.htm