修改Oracle连接数

sqlplus / as sysdba

当前数据库进程的连接数

select count(1) from v$process;

当前会话的连接数

select count(1) from v$session;

查看最大连接数

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

修改最大连接数为3000

alter system set processes = 3000 scope = spfile;

重启数据库

shutdown immediate;  startup;

查看最大连接数是否修改生效

show parameter processes;

查看当前连接数消耗情况

select b.MACHINE, b.PROGRAM, b.USERNAME, count(*) from v$process a, v$session b where a.ADDR = b.PADDR and b.USERNAME is not null group by b.MACHINE, b.PROGRAM, b.USERNAME order by count(*) desc;