oracle查看session数
select * from v$session
查看当前不为空的连接
select * from v$session where username is not null
#查看不同用户的连接数
select username,count(username) from v$session where username is not null group by username
#连接数
select count(*) from v$session
#并发连接数
Select count(*) from v$session where status='ACTIVE'
#最大连接
show parameter processes
#修改连接
alter system set processes = value scope = spfile