oracle last connexion code example

Example: oracle last connexion

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;