user details

select rpad(username,10,' ') as "DB User",
to_char(logon_time,'hh24:mi Mon/dd') as "Logon Time",
initcap(status) as "Status",sid||','||serial# as "Session",process as "Process",
rpad(upper(substr(program,instr(program,'\',-1)+1)),25,' ') as "Program",
rpad(lower(osuser),10,' ') as "OS User",
rpad(initcap(machine),15,' ') as "Machine Name" from v$session
where username like upper('%&USERNAME%')
order by machine,program;