DBA_AUDIT_POLICIES

All fine grained auditing policies in the database

Columns
   ___________________________
 
   OBJECT_SCHEMA
      Owner of the table or view
   OBJECT_NAME
      Name of the table or view
   POLICY_NAME
      Name of the policy
   POLICY_TEXT
      Audit condition
   POLICY_COLUMN
      Relevant column
   PF_SCHEMA
      Owner of the audit handler function
   PF_PACKAGE
      Name of the package containing the audit handler function
   PF_FUNCTION
      Name of the audit handler function
   ENABLED
      Is this policy is enabled?
   SEL

   INS

   UPD

   DEL

   AUDIT_TRAIL

   POLICY_COLUMN_OPTIONS

Related:

DBA_COMMON_AUDIT_TRAIL