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