Skip to content

Where is AUDIT_FILE_DEST (ADUMP)

  • by

Audit File Location

The audit file location AUDIT_FILE_DEST, also known as ADUMP may be different from version to version.

For 10g and later releases

Conventionally, we call audit file location as ADUMP, so the default audit file location for 10g and later releases is at:

$ORACLE_BASE/admin/<DB_UNIQUE_NAME>/adump

In fact, the actual path of audit files is defined by AUDIT_FILE_DEST. For example:

SQL> show parameter audit_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/app/oracle/admin/ORCLCDB/
                                                 adump

Of course, you can change it as you want.

Beside ADUMP, there're several other dump destinations defined in Oracle database.

  • BDUMP: BACKGROUND_DUMP_DEST
  • CDUMP: CORE_DUMP_DEST
  • UDUMP: USER_DUMP_DEST

For 9i and earlier releases

There's no concept of ADUMP for earlier releases. So the default audit file location is at:

$ORACLE_HOME/rdbms/audit

For example, in an Oracle 9i database.

SQL> column type format a11;
SQL> show parameter audit_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      ?/rdbms/audit

Where ? (question mark) means $ORACLE_HOME.

Leave a Reply

Your email address will not be published.