Configure Oracle Audit (SQL)

Prev Next

Note

The supported parser queries the DB_Audit_Trail table within the database to pull events. As this table grows, performance slows noticeably because two values must be pulled into the query: Timestamp and Transaction_ID. To alleviate impact on performance, index the table. If there is still a considerable impact after indexing, use another option (Syslog, flat File, etc.) to pull audit data.

  1. Enter db as the AUDIT_TRAIL parameter. For example:

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

  3. Enable auditing for the appropriate tables.