Database Administration - Dump Destination

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 229 of 231

Dump Destination

What is dump destination? What are bdump, cdump and udump? Explain in detail.

Total Answers and Comments: 4

Last Update: October 31, 2009 Asked by: gyanudba

Sponsored Links

Best Rated Answer

—

Submitted by: khaundanupam

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.

Above answer was rated as good by the following members:
rakeshsb

February 11, 2009 06:30:55

khaundanupam

Member Since: February 2009 Contribution: 3

RE: Dump Destination

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.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

February 26, 2009 05:25:31

rajat.dua09

Member Since: February 2009 Contribution: 1

RE: Dump Destination

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

July 06, 2009 10:06:17

aravindhreturns

Member Since: July 2009 Contribution: 5

RE: Dump Destination

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 :)

Is this answer useful? Yes | No

October 30, 2009 13:46:44

anurag2202

Member Since: October 2009 Contribution: 1

RE: Dump Destination

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank