Oracle查询最大连接数和当前连接数

select value as maxconnectnum,nowconnectnum from v$parameter a
left join (
select count(*) nowconnectnum from v$process) b on 1=1
where name = 'processes';
  ;
1
2
3
4
5