Audit File Location
The audit file location AUDIT_FILE_DEST, also known as ADUMP, is the parameter that specifies the destination of audit files in a database. It 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