@long_date
col machine for a10
select sid, logon_time, status, machine, sysdate - last_call_et / 86400 "Last-Active"
from v$session where username='&username' order by logon_time
/
