SQL> select * from dictionary where upper(comments) like '%AUDIT%';

TABLE_NAME                     COMMENTS
------------------------------ ------------------------------------------------------------
USER_AUDIT_SESSION             All audit trail records concerning CONNECT and DISCONNECT
USER_AUDIT_STATEMENT           Audit trail records concerning  grant, revoke, audit, noaudi
                               t and alter system

USER_AUDIT_OBJECT              Audit trail records for statements concerning objects, speci
                               fically: table, cluster, view, index, sequence,  [public] da
                               tabase link, [public] synonym, procedure, trigger, rollback
                               segment, tablespace, role, user

USER_AUDIT_TRAIL               Audit trail entries relevant to the user
USER_OBJ_AUDIT_OPTS            Auditing options for user's own tables and views with atleas
                               t one option set

ALL_DEF_AUDIT_OPTS             Auditing options for newly created objects
ALL_AUDIT_POLICIES             All fine grained auditing policies in the database
ALL_AUDIT_POLICY_COLUMNS       All fine grained auditing policy columns in the database
USER_AUDIT_POLICIES            All fine grained auditing policies for objects in user schem
                               a

USER_AUDIT_POLICY_COLUMNS      Users fine grained auditing policy columns in the database
AUDIT_ACTIONS                  Description table for audit trail action type codes.  Maps a
                               ction type numbers to action type names


11 rows selected.

SQL>