Oracle audit

Audit on DML

select * from DBA_AUDIT_POLICIES ;

select * from DBA_FGA_AUDIT_TRAIL where OS_USER <> 'vcap' ;
select count(*) from DBA_FGA_AUDIT_TRAIL where OS_USER <> 'vcap' ;
select min(TIMESTAMP) from DBA_FGA_AUDIT_TRAIL ;

Audit on DDL

SELECT * FROM DBA_STMT_AUDIT_OPTS ORDER BY AUDIT_OPTION;
SELECT * FROM DBA_PRIV_AUDIT_OPTS ORDER BY PRIVILEGE;

SELECT * FROM DBA_AUDIT_TRAIL WHERE ACTION_NAME NOT LIKE 'LOG%';


AUDIT ALTER ANY PROCEDURE              ; 
AUDIT ALTER ANY TABLE                  ;
AUDIT ALTER DATABASE                   ;
AUDIT ALTER PROFILE                    ;
AUDIT ALTER SYSTEM                     ;
AUDIT ALTER USER                       ;
AUDIT CREATE ANY JOB                   ;
AUDIT CREATE ANY LIBRARY               ;
AUDIT CREATE ANY PROCEDURE             ;
AUDIT CREATE ANY TABLE                 ;
AUDIT CREATE EXTERNAL JOB              ;
AUDIT CREATE PUBLIC DATABASE LINK      ;
AUDIT CREATE SESSION                   ;
AUDIT CREATE USER                      ;
AUDIT DATABASE LINK                    ;
AUDIT DIRECTORY                        ;
AUDIT DROP ANY PROCEDURE               ;
AUDIT DROP ANY TABLE                   ;
AUDIT DROP PROFILE                     ;
AUDIT DROP USER                        ;
AUDIT EXEMPT ACCESS POLICY             ;
AUDIT GRANT ANY OBJECT PRIVILEGE       ;
AUDIT GRANT ANY PRIVILEGE              ;
AUDIT GRANT ANY ROLE                   ;
AUDIT PROFILE                          ;
AUDIT PUBLIC SYNONYM                   ;
AUDIT ROLE                             ;
AUDIT SYSTEM AUDIT                     ;
AUDIT SYSTEM GRANT                     ;