查看oracle的连接数
select count(*) from v$session;
查看当前的连接数
select count(*) from v$process
查询oracle的并发连接数
select count(*) from v$session where status='ACTIVE';
查看不同用户的连接数
select username,count(username) from v$session where username is not null group by username;
查看并发连接数
select count(*) from v$session where status='ACTIVE'
按照主机名称查询连接数
SELECT COUNT(*) FROM V$SESSION WHERE MACHINE = 'DXMH';