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;
查看oracle连接数以及活跃连接数
最新推荐文章于 2024-03-07 11:21:24 发布