How to get the list of open session for an username

To be executed as SYSTEM :

select username, osuser, machine, terminal, status from v$session where username = 'MYUSER'

Published 15th Mar 2011 // #oracle #tips




comments powered by Disqus