DBA AUDIT TRAIL

col USERNAME for a10
col OS_USERNAME for a10
col USERHOST for a15
col ACTION_NAME for a11
set pages 200 lines 100
alter session set nls_date_format='DD-MON-YY HH24:MI:SS';
select USERNAME,OS_USERNAME,USERHOST,TIMESTAMP,ACTION_NAME,LOGOFF_TIME from dba_audit_trail where username='&username' order by 3;