1、取得目前的进程及会话数
select count(*) from v$process;
select count(*) from v$session;
2、取得进程数的上限
select value from v$parameter where name = 'processes';
3、SQL> conn / as sysdba
SQL> alter system set processes=3000 scope=spfile; --设置最大进程数为3000
SQL> alter system set sessions=3000 scope=spfile; --设置最大会话数为3000
SQL> shutdown immediate; --重启才能生效
SQL> startup;
SQL> show parameter processes;
SQL> show parameter sessions;