查询oracle数据库连接数

查询数据库连接数
select count(*) from v$session

select v.PROGRAM,v.* from v$session v  where v.PROGRAM like '%JDBC%' ;
select v.STATUS,count(1) from v$session v  where v.PROGRAM like '%JDBC%' group by v.STATUS ;
select v.STATE,count(1) from v$session v  where v.PROGRAM like '%JDBC%' group by v.STATE ;