SELECT a.USERNAME, max(TIMESTAMP) FROM DBA_AUDIT_TRAIL a WHERE ACTION_NAME = 'LOGON' AND USERNAME IN ('MY_USER') GROUP BY USERNAME ORDER BY 1;