SYS.AUD$ Purging

col OS_USERNAME for a10;

col USERNAME for a10;

col TIMESTAMP for a10;

col OWNER for a10;

col OBJ_NAME for a10;

col ACTION for a20;

select OS_USERNAME,USERNAME,TIMESTAMP,OWNER,OBJ_NAME,ACTION from dba_audit_trail order by TIMESTAMP;

select Min(NTIMESTAMP#) “Last AUD$ Purge Date ” from sys.aud$

where OBJ$NAME !=’AUD$’;

SQL> select min(timestamp#)from sys.aud$;

MIN(NTIMESTAMP#)

——————————————

15-SEP-09 10.25.46.010659 PM

SQL> select max(ntimestamp#)from sys.aud$;

MAX(NTIMESTAMP#)

——————————————

09-FEB-10 08.43.41.463174 AM