Oracle SQL query that shows Oracle users connected and the sessions number for user



SELECT username Usuario_Oracle, COUNT (username) Numero_Sesiones
    FROM v$session
GROUP BY username
ORDER BY Numero_Sesiones DESC;
  • April 16, 2015 | 48 views
  • Comments