AUDIT_TRAIL

AUDIT_TRAIL enables or disables database auditing.

Values:

• none

  Disables database auditing.

• os

  Enables database auditing and directs all audit records to the operating system's audit trail.

• db

  Enables database auditing and directs all audit records to the database audit trail (the SYS.AUD$ table).

• db,extended

  Enables database auditing and directs all audit records to the database audit trail (the SYS.AUD$ table). In addition, populates the SQLBIND and SQLTEXT CLOB columns of the SYS.AUD$ table.

• xml

  Enables database auditing and writes all audit records to XML format OS files.

• xml,extended

  Enables database auditing and prints all columns of the audit trail, including SqlText and SqlBind values.

You can use the SQL statement AUDIT to set auditing options regardless of the setting of this parameter.