to check last login in oracle query

select username, max(logoff_time) from dba_audit_trail group by username;