List current active users, sessions and programs in Oracle 11g

List current users, sessions and programs
(not background processes)

SELECT username, sid, serial#, program
FROM v$session
WHERE username is NOT NULL
ORDER BY logon_time;

Remove there WHERE clause if you want to include all background processes like pmon.