Forum Stats

  • 3,840,371 Users
  • 2,262,594 Discussions
  • 7,901,249 Comments

Discussions

Uniqueness of a row in audit trail

Is it true that the combination of sessionid and entryid of dba_audit_trail, or sessionid and entry_id of unified_audit_trail, is unique in the audit trail view? Documentation about the two columns regardless Oracle version is:

Dba_audit_trail:

Sessionid: Numeric ID for each Oracle session. Each user session gets a unique session ID.

Entryid: Numeric ID for each audit trail entry in the session. The entry ID is an index of a session's audit entries that starts at 1 and increases to the number of entries that are written.

Unified_audit_trail:

Sessionid: Audit session identifier

Entry_id: Numeric ID for each audit trail entry in the session