查看不同用户的连接数--
select username, count(username) from v$session where username is not null group by username;
查询终端用户使用数据库的连接情况--
select osuser, count(*) conn from v$session group by osuser order by conn desc;
查看不同用户的连接数--
select username, count(username) from v$session where username is not null group by username;
查询终端用户使用数据库的连接情况--
select osuser, count(*) conn from v$session group by osuser order by conn desc;
原文：https://www.cnblogs.com/yanjie-java/p/8117036.html