khaundanupam

 Profile Answers by khaundanupam 

• Feb 11th, 2009

 

The dump destination is the location where the trace files are located for all the Oracle process

bdump-->Background processes + alert_SID.log file location
cdump--> Core Processes dump
udump--> User Processes dump
adump--> for ASM processes

These destinations contains useful information related to process failures.

rajat.dua09

 Profile Answers by rajat.dua09 

• Feb 26th, 2009

 

In 11g, this concept has been replaced with diagnostic test!

aravindhreturns

 Profile Answers by aravindhreturns 

• Jul 6th, 2009

 

UDUMP is specifying the user dump directory where all user error logs (trace files) will be placed.
BDUMP is specifying the background dump directory where all database error logs (trace files) will be placed.
CDUMP is specifying the core dump directory where all OS error logs (core dump files) will be placed.

Default location is ( ORACLE_BASE/admin/<SID> )

Login as root:
SYNTAX : sqlplus "/ as sysdba"

Then issue this command
SYNTAX : show parameters dump_dest
It'll show you all the bdump, cdump and udump directories wherever it is currently located.

You can change your parameters in init.ora by creating spfile from pfile.
SYNTAX : Create SPFILE from PFILE



Guess this is what you need :)

anurag2202

 Profile Answers by anurag2202 

• Oct 30th, 2009

 

The dump destination is: Oracle_home/admin/<SID>

The UDUMP specifies user dump directory where all the user related information is stored in the form of trace file.

The BDUMP specifies background dump directory where background processes information and error logs are stored in the form of alert log file.

The CDUMP specifies core dump directory where all the information related to core operations performed by oracle is stored.