当前位置:Gxlcms > 数据库问题 > 查看oracle连接数和会话情况

查看oracle连接数和会话情况

时间:2021-07-01 10:21:17 帮助过:80人阅读

 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

查看oracle连接数和会话情况

标签:word   process   tran   esc   ora   ssi   not   machine   sof   

人气教程排行