查看oracle连接数以及活跃连接数

select t.INST_ID,
       count(*) count_all,
       sum(case
             when t.STATUS = 'ACTIVE' then
              1
             else
              0
           end) count_active
  from gv$session t
 group by t.INST_ID
 order by t.inst_id;