select username from v$session
where sid > 6;

(The sid > 6 is so you will see actual users, not Oracle processes)