select value as processes_max from v$parameter where name ='processes'; --数据库允许的最大连接数 结果4000
select count(*) as process_now from v$process; --当前进程连接数
select value as session_max from v$parameter where name ='sessions'; --数据库最大session数
select count(*) as session_now from v$session; --当前的session连接数
select count(*) as active_now from v$session where status='ACTIVE'; --并发连接数