select s.sid, s.serial#,u.username
from v$session s, dba_users u
where  s.user#=u.user_id
and u.username = 'HR'