LLI Wiki — My Digital Knowledge Base

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

Mastodon LLIMastodon SocialFosstodon