1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. AUDIT_FILE_DEST

2.24 AUDIT_FILE_DEST

AUDIT_FILE_DEST specifies the operating system directory into which the audit trail is written when the AUDIT_TRAIL initialization parameter is set to os, xml, or xml,extended.

Note:

This parameter is deprecated and applies only to traditional auditing. Traditional auditing is desupported starting in Oracle Database 23ai. Though traditional auditing is desupported, any current traditional audit settings that you have will still be honored. However, you cannot create new traditional audit settings. You can delete existing traditional audit settings. See Oracle Database Security Guide for more information about how this desupport works.

Property Description

Parameter type

String

Syntax

AUDIT_FILE_DEST = 'directory'

Default value

The first default value is:

ORACLE_BASE/admin/ORACLE_SID/adump

The second default value, which is used if the first default value does not exist or is unusable, is:

ORACLE_HOME/rdbms/audit

Both of these default values are for UNIX systems. Other platforms may have different defaults.

In a multitenant container database (CDB), both of these default values will be appended with the GUID of the pluggable database (PDB) to store audit records that belong to the PDB. For example, if the PDB's GUID is 03E1F908EE04252CE053B280E80AAAA3, the first default directory will be:

ORACLE_BASE/admin/ORACLE_SID/adump/03E1F908EE04252CE053B280E80AAAA3

You can use the V$CONTAINERS view to query a PDB's GUID.

Modifiable

ALTER SYSTEM ... DEFERRED

Modifiable in a PDB

No

Basic

No

The audit records will be written in XML format if the AUDIT_TRAIL initialization parameter is set to xml or xml, extended. It is also the location to which mandatory auditing information is written and, if so specified by the AUDIT_SYS_OPERATIONS initialization parameter, audit records for user SYS.

In a multitenant container database (CDB), the scope of the settings for this initialization parameter is the CDB. Although the audit trail is provided per pluggable database (PDB) in a CDB, this initialization parameter cannot be configured for individual PDBs.

See Also: