数据库允许的最大连接数:
select value as processes_max from v$parameter where name ='processes';
当前进程连接数:
select count(*) as process_now from v$process;
数据库最大session数:
select value as session_max from v$parameter where name ='sessions';
当前的session连接数:
select count(*) as session_now from v$session;
并发连接数:
select count(*) as active_now from v$session where status='ACTIVE';
修改数据库允许的最大连接数:
alter system set processes=3000 scope=spfile;
修改后需要重启oracle生效:
SQL> shutdown immediate;
SQL> startup;