1、查看:
select to_char(a.tt) as 当前连接数,to_char(b.tt1) as 最大连接数 from (select count(*) as tt from v$process) a,(select value as tt1 from v$parameter where name ='processes') b
2、修改:
alter system set processes = 300 scope =spfile;
3、重启服务
1、查看:
select to_char(a.tt) as 当前连接数,to_char(b.tt1) as 最大连接数 from (select count(*) as tt from v$process) a,(select value as tt1 from v$parameter where name ='processes') b
2、修改:
alter system set processes = 300 scope =spfile;
3、重启服务