select count(*) from v$session #连接数
Select count(*) from v$session where status='ACTIVE' #并发连接数
select value from v$parameter where name = 'processes';
show parameter processes #最大连接
alter system set processes = value scope = spfile;重启数据库 #修改连接
Select count(*) from v$session where status='ACTIVE' #并发连接数
select value from v$parameter where name = 'processes';
show parameter processes #最大连接
alter system set processes = value scope = spfile;重启数据库 #修改连接