List user sessions

Skips background processes with null user name

set pagesize 40
set linesize 100
column program  format a40
column username format a20

select  username,
        logon_time,
        sid,
        serial#,
        program
        from v$session
        where username is not null
        order by logon_time
        ;