CODE EXAMPLE FOR SQL

check database sessions oracle

-- Order sessions by app
select program Aplicacion, count(program) Numero_Sesiones
from v$session
group by program 
order by Numero_Sesiones desc