There is a table called v$session, which is visible if you haveDBA privileges. This table contains an entry for each session connected to the Oracle database. To see who is connected to the database, use the following command:
SELECT usernameFROM v$session;