View the number of Oracle current connections ____oracle

1. View Oracle Max Connection number
Sql>show parameter Processes #最大连接数

2. Modify the maximum number of connections
Sql>alter system set Processes=value Scope=spfile
Restart the database
Sql>shutdown Force
Sql>start Force

3. View the current number of connections
Sql>select * from v$session where username isn't null

4. View the number of connections for different users
Sql>select Username,count (username) from V$session where username was not null GROUP by username #查看指定用户的连接数

5. View the number of concurrent connections
Sql>select Count (*) from v$session where status= ' ACTIVE ' #查看并发连接数

6. Check the number of connections to the specified program
Sql>select Count (*) from v$session where program= ' JDBC Thin Client ' #查看JDBC连接Oracle的数目