Find out current logged in users

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