如何查看oracle当前连接数,会话数

  • Post author:
  • Post category:其他


查看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

查看连接数参数的设置情况

select value from v$parameter where name = ‘processes’

Select count(*) from v$session where status=’ACTIVE’ #并发连接数



版权声明:本文为miwucc原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。