oracle last connection code example

Example: oracle last connection

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;