Oracle Cloud Infrastructure Documentation

Audit Trails

An audit trail is a table in a database that stores audit data. A widely used audit trail is the AUDSYS.UNIFIED_AUDIT_TRAIL data dictionary view, which consolidates all Oracle Database audit trails into one location and in a unified format. You can configure audit trails in Oracle Data Safe. In most cases, you configure only one audit trail per database.

When audit data collection is enabled, Oracle Data Safe copies the audit data from the database's audit trail into the Oracle Data Safe audit table. Over time an audit trail can become quite large, therefore, you may want to consider the auto purge feature in Oracle Data Safe. You can start and stop audit collection as needed.

Cloud Database Service Database Versions Supported Audit Trail Locations
  • Bare Metal DB system
  • Virtual Machine DB system

Standard Edition is not supported.

12.2.0.1

18.1.0.1

19.1

SYS.AUD$

SYS.FGA_LOG$

DVSYS.AUDIT_TRAIL$ (when Database Vault is enabled)

AUDSYS.UNIFIED_AUDIT_TRAIL

  • Autonomous Data Warehouse (serverless)
  • Autonomous Transaction Processing (serverless)

latest version

AUDSYS.UNIFIED_AUDIT_TRAIL