Skip to content

Instantly share code, notes, and snippets.

@craibuc

craibuc/gist:5813835

Created June 19, 2013 12:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save craibuc/5813835 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save craibuc/5813835 to your computer and use it in GitHub Desktop.
Download ZIP
List of Oracle sessions for current user.
Raw
gistfile1.sql
SELECT SID, USERNAME, SCHEMANAME, OSUSER, MACHINE, TERMINAL, PROGRAM, TYPE, MODULE, ACTION, LOGON_TIME
FROM V$SESSION
-- current user
WHERE USERNAME = USER
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment