dont u use following query
select terminal,machine,username from v$session
where username is not null