oracle当前连接数,会话数

来源:互联网 发布:思科网络技术学院4本书 编辑:程序博客网 时间:2024/05/22 00:42


 1.查看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
 2.当前连接数:
       select count(*) from v$process
 3.查看连接数参数的设置情况
  select value from v$parameter where name = 'processes'
  Select count(*) from v$session where status='ACTIVE' #并发连接数


0 0
原创粉丝点击