Skip to content

Instantly share code, notes, and snippets.

@joseporiol

joseporiol/open_conn_by_program.sql

Created January 21, 2014 10:22
Show Gist options
  • Save joseporiol/8537594 to your computer and use it in GitHub Desktop.
Save joseporiol/8537594 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle SQL query that show the opened connections group by the program that opens the connection.
Raw
open_conn_by_program.sql
SELECT program application, COUNT (program) Numero_Sesiones
FROM v$session
GROUP BY program
ORDER BY Numero_Sesiones DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment