query audi

　

select * from STMT_AUDIT_OPTION_MAP;

select * from AUDIT_ACTIONS;

select * from ALL_DEF_AUDIT_OPTS;

select * from DBA_STMT_AUDIT_OPTS;

select * from DBA_PRIV_AUDIT_OPTS;

select * from DBA_OBJ_AUDIT_OPTS;

select * from USER_OBJ_AUDIT_OPTS;

select * from USER_AUDIT_TRAIL;

select * from DBA_AUDIT_OBJECT where OS_USERNAME in ('');

　

select DISTINCT(OS_USERNAME) from DBA_AUDIT_OBJECT;

　

　

select * from DBA_AUDIT_OBJECT where OS_USERNAME='';

select * from USER_AUDIT_TRAIL;

　

select * from USER_AUDIT_TRAIL WHERE OS_USERNAME =''--NOT IN ('applp','');

　

EDIT dba_audit_trail

　

EDIT SYS.aud$

　

select DISTINCT(OS_USERNAME) from USER_AUDIT_TRAIL;-- WHERE OS_USERNAME NOT IN ('applp','oascd');

　

select DISTINCT(OS_USERNAME)from USER_AUDIT_TRAIL;