Skip to content

Instantly share code, notes, and snippets.

@rodrigo-galba

rodrigo-galba/gist:559504

Created August 31, 2010 18:50
Show Gist options
  • Save rodrigo-galba/559504 to your computer and use it in GitHub Desktop.
Save rodrigo-galba/559504 to your computer and use it in GitHub Desktop.
Download ZIP
Select para listar usuarios conectados no oracle
Raw
gistfile1.txt
SELECT s.username, s.program, s.logon_time, s.osuser, s.machine
FROM v$session s, v$process p, sys.v_$sess_io si
WHERE s.paddr = p.addr(+)
AND si.sid(+) = s.sid
AND s.username = 'SYSPDVWEB_LANCEUNICO_TEST';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment