Oracle how do i see who connected to my database
you need auditing in your database, by default Oracle database audit LOGON/LOGOFF action, please take a look into following article Auditing in Oracle 10g Release 2. query from DBA_AUDIT_TRAIL is a good starting point