To modify the maximum number of Oracle connections

To modify the maximum number of Oracle connections

1. Ways to modify the maximum number of connections for Oracle

A, landing in SYSDBA status of PL/SQL or Worksheet
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 Pfile
Create Pfile from SPFile;
E. Restart the Oracle service or restart the Oracle server

2. How to query Oracle cursor usage
SELECT * from v$open_cursor where user_name = ' traffic ';
3. How to query Oracle session
SELECT * FROM V$session

To modify the maximum number of Oracle connections