check database sessions oracle
select osuser, username, machine, program
from v$session
order by osusercheck database sessions oracle
select osuser, username, machine, program
from v$session
order by osusercheck database sessions oracle
-- Sessions by user
select username Usuario_Oracle, count(username) Numero_Sesiones
from v$session
group by username
order by Numero_Sesiones desccheck database sessions oracle
-- Order sessions by app
select program Aplicacion, count(program) Numero_Sesiones
from v$session
group by program
order by Numero_Sesiones descCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
