Configure Oracle Audit (XML)

Prev Next
  1. Enter XML as the AUDIT_TRAIL parameter. For example:

    ALTER SYSTEM SET AUDIT_TRAIL=XML;
  2. Restart the service for the change to take effect.

  3. Enable auditing for the appropriate tables.

  4. Optionally, change the directory in which audit trail files are written. For example:

    ALTER SYSTEM SET AUDIT_FILE_DEST = ‘/audit_trail’ DEFERRED;
  5. Navigate to the file destination you set, and open the XML once it is generated. Ensure that the audit trail is being written inside that file.