Oracle 查看当前连接数与会话数情况

来源:互联网 发布:如何防噪音知乎 编辑:程序博客网 时间:2024/05/16 13:55

select  b.MACHINE, b.PROGRAM , count(*) from v$process a, v$session b where a.ADDR = b.PADDR and  b.USERNAME is not null   group by  b.MACHINE  , b.PROGRAM order by count(*) desc



select INST_ID, count(*) from gv$session  g group by g.INST_ID

0 0
原创粉丝点击