1、使用sqlplus登录,查询当前的连接数
select count(*) from v$process;
2、设置的最大连接数(默认值为150)
select value from v$parameter where name = 'processes';
3、修改最大连接数
alter system set processes = 600 scope = spfile;
select count(*) from v$process;
select value from v$parameter where name = 'processes';
alter system set processes = 600 scope = spfile;