Oracle: what the bdump, udump, dpdump, adump and cdump directories hold
What each Oracle diagnostic directory contains and how to locate bdump and udump.
Oracle writes diagnostic and audit files into several directories whose names end in dump. This is what each one contains.
| Directory | Content |
|---|---|
bdump |
Trace files of the background processes (LGWR, DBWn, and so on) |
udump |
Trace files written on behalf of a user process |
dpdump |
Files created by the Data Pump export/import utilities |
adump |
Audit trace files |
cdump |
Core dump files (OS error dumps) |
Locate bdump and udump
Their location is given by initialization parameters:
SQL> show parameter BACKGROUND_DUMP_DEST
SQL> show parameter USER_DUMP_DEST
On a Windows 10.2 installation they typically look like this:
C:\ORACLE\PRODUCT\10.2.0\ADMIN\<SID>\BDUMP
C:\ORACLE\PRODUCT\10.2.0\ADMIN\<SID>\UDUMP
Notes
BACKGROUND_DUMP_DESTandUSER_DUMP_DESTare deprecated since Oracle 11g, where trace and alert files are under the Automatic Diagnostic Repository (DIAGNOSTIC_DEST).