all_def_audit_opts
audit_actions
dba_audit_object
dba_audit_session.session_cpu = statistic 'CPU used by this session'
dba_audit_statement;
dba_audit_trail.comment_text
dba_obj_audit_opts;
dba_priv_audit_opts;
dba_stmt_audit_opts;

select * from dba_obj_audit_opts where alt = chr(0)||'/'||chr(0);

audit session by CCDAKKS,MSHELAR;


All DDLs except COMMENT (just say audit that for each one):

CLUSTER
CONTEXT
DATABASE LINK
DIMENSION
DIRECTORY
INDEX
PROCEDURE
PROFILE
PUBLIC DATABASE LINK
PUBLIC SYNONYM
ROLE
ROLLBACK SEGMENT
SEQUENCE
SYNONYM
SYSTEM AUDIT
SYSTEM GRANT
TABLE
TABLESPACE
TRIGGER
TYPE
USER
VIEW

ALTER SEQUENCE
ALTER TABLE
GRANT DIRECTORY
GRANT PROCEDURE
GRANT SEQUENCE
GRANT TABLE
GRANT TYPE



What is being audited:

select distinct audit_option from dba_stmt_audit_opts;
select distinct privilege from dba_priv_audit_opts;
SELECT * FROM dba_obj_audit_opts
WHERE ALT='S/S' or ALT='-/S' or ALT='S/-' or ALT='A/S' or ALT='S/A'
or    AUD='S/S' or AUD='-/S' or AUD='S/-' or AUD='A/S' or AUD='S/A'
or    COM='S/S' or COM='-/S' or COM='S/-' or COM='A/S' or COM='S/A'
or    DEL='S/S' or DEL='-/S' or DEL='S/-' or DEL='A/S' or DEL='S/A'
or    GRA='S/S' or GRA='-/S' or GRA='S/-' or GRA='A/S' or GRA='S/A'
or    IND='S/S' or IND='-/S' or IND='S/-' or IND='A/S' or IND='S/A'
or    INS='S/S' or INS='-/S' or INS='S/-' or INS='A/S' or INS='S/A'
or    LOC='S/S' or LOC='-/S' or LOC='S/-' or LOC='A/S' or LOC='S/A'
or    REN='S/S' or REN='-/S' or REN='S/-' or REN='A/S' or REN='S/A'
or    SEL='S/S' or SEL='-/S' or SEL='S/-' or SEL='A/S' or SEL='S/A'
or    UPD='S/S' or UPD='-/S' or UPD='S/-' or UPD='A/S' or UPD='S/A'
or    REF='S/S' or REF='-/S' or REF='S/-' or REF='A/S' or REF='S/A'
or    EXE='S/S' or EXE='-/S' or EXE='S/-' or EXE='A/S' or EXE='S/A'
or    CRE='S/S' or CRE='-/S' or CRE='S/-' or CRE='A/S' or CRE='S/A'
or    REA='S/S' or REA='-/S' or REA='S/-' or REA='A/S' or REA='S/A'
or    WRI='S/S' or WRI='-/S' or WRI='S/-' or WRI='A/S' or WRI='S/A';