column program format a30
column machine format a30

select username, machine, program, to_char(logon_time,'DD-MM-YYYY hh24:mi') from v$session where username is not null;