There is a table called v$session, which is visible if you have
DBA 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 username
FROM v$session;