How to get the list of open session for an username 15 March 2011·30 words·1 min Oracle Tips 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'