Oracle数据库查看并修改最大连接数

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、重启服务