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

1、查看当前的数据库连接数

select count(*) from v$process;

2、数据库允许的最大连接数

select value from v$parameter where name ='processes';

3、修改数据库最大连接数

----设置数据库最大连接数为2000
alter system set processes=2000 scope = spfile; 
----关闭/重启数据库
SQL> shutdown immediate
SQL> startup

···················································································································个人备用