查看oracle连接数和会话情况

最新推荐文章于 2024-03-25 10:59:53 发布

weixin_30629977

最新推荐文章于 2024-03-25 10:59:53 发布

阅读量513

点赞数

文章标签：数据库操作系统

原文链接：http://www.cnblogs.com/huangdewei/p/6654485.html

版权

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

或者

查看session：
　　select * from v$session where username is not null
　　select username,count(username) from v$session where username is not null group by username
　　当前连接数：
　　select count(*) from v$process

转载于:https://www.cnblogs.com/huangdewei/p/6654485.html