Overview

Auditing in Oracle is controlled by the audit_trail. Audit trail can be:

None = Doesn't store Audit data

DB = Audit information is stored in the DB (aud$ and dba_audit_trail)

OS = Audit Information is stored on the OS (Audit_dump_location)

XML = Writes to the operating system audit record file in XML format. Prints all elements of the AuditRecord node

*EXTENDED = Addition to (DB and XML) Provides further audit data

Auditing

Tracing

Tracing can be enabled for:

Current Session

Specific Session

Upon login

Specific Service

Specific OS Process

Current Session

Specific Session

Specific OS Process

Login

Tracing can be enabled on LOGON via trigger as follows:

Pre 12c

Post 12c

Specific Client