查询并显示连接 Oracle 的用户和用户的会话数量

select username usuario_oracle, count(username) numero_sesiones
from gv$session
group by username order by numero_sesiones desc;