oracle如何查看当前有哪些用户连接到数据库

select username,count(username) from v$session where username is not null group by username;
select o.sid, osuser, machine, count(*) num_curs  from v$open_cursor o, v$session s  where user_name = SYSTEM and o.sid=s.sid   group by o.sid, osuser, machine  order by num_curs desc;

原创文章，作者：kepupublish，如若转载，请注明出处：https://blog.ytso.com/58086.html