Wednesday, August 31, 2011

What are bdump,udump,dpdump,adump and cdump in oracle?


Below is the description of all. Have a look!

BDUMP:

SQL> show parameter BACKGROUND_DUMP_DEST

C:\ORACLE\PRODUCT\10.2.0\ADMIN\<SID>\BDUMP

This shows the bdump directory you were referring to in your question. This is a directory where debugging trace files for the background processes (LGWR, DBWn, and so on) are written. 

UDUMP:

SQL> show parameter USER_DUMP_DEST

C:\ORACLE\PRODUCT\10.2.0\ADMIN\<SID>\UDUMP

This specifies the pathname for a directory where debugging trace files will be written on behalf of a user process.

DPDUMP:

The dpdump directory has files created by the data pump export/import utility.

ADUMP:

The adump directory is the area where auditing trace files are stored.

CDUMP:

CDUMP is specifying the core dump directory where all OS error logs (core dump files) will be placed.

Enjoy:-)

22 comments:

Bulachi said...

The CDUMP i can to delete when the FileSystem(Solaris) is full?

Bulachi said...

i can to delete the Cdump when my FileSystem(Solaris) is full?

Anonymous said...

Certainly, Bulachi, my friend.

Teguh said...

dear Mr Sharma,
Can we delete the udump file (*trc) while the oracle running (up)?

Vishwanath Sharma said...

Yes

Anonymous said...

Udump gets full whcih leads to low disk space .Once in a week i delete those files but still it gets loaded. What to do?

Anonymous said...

Link exchange is nothing else but it is just placing the other person's website link on your page at suitable place and other person will also do similar in support of you.

Feel free to surf to my web blog - us business directory listing

Anonymous said...

I absolutely love your blog and find most of your post's to be what precisely I'm looking for.
Do you offer guest writers to write content for you? I wouldn't mind producing a post or elaborating on many of the subjects you write with regards to here. Again, awesome weblog!

Review my page; real estate listing

Anonymous said...

Greetings! I know this is somewhat off topic but I was wondering if you knew where I could find a captcha plugin for my comment form?
I'm using the same blog platform as yours and I'm having trouble finding one?
Thanks a lot!

My page :: laptop repair charlotte north carolina

Anonymous said...

Thanks for another fantastic post. The place else could anybody
get that kind of info in such a perfect approach of writing?
I have a presentation next week, and I am on the look for such info.


Feel free to visit my web page; introduction to a research paper

Anonymous said...

It's the best time to make some plans for the future and it is time to be happy. I've read this post and if I
could I wish to suggest you few interesting things or suggestions.
Maybe you can write next articles referring to this article.
I wish to read even more things about it!

Have a look at my page ... sample research paper in apa format

Anonymous said...

Heya i am for the first time here. I found this
board and I find It truly useful & it helped me out much.
I'm hoping to give something again and aid others such as you helped me.

My web-site :: charlotte nc virus removal

Anonymous said...

Nice blog right here! Also your web site lots up very fast!
What host are you the usage of? Can I am getting your
affiliate link on your host? I want my website loaded up
as quickly as yours lol

My homepage - local small buisness directory and white pages

Anonymous said...

What i do not realize is actually how you're now not actually much more neatly-preferred than you may be right now. You are very intelligent. You understand therefore significantly with regards to this subject, made me in my view consider it from numerous varied angles. Its like women and men are not involved until it is one thing to do with Girl gaga! Your personal stuffs nice. All the time deal with it up!

My web site: gangster bugs bunny t-shirts

Anonymous said...

I am really loving the theme/design of your weblog.
Do you ever run into any browser compatibility issues?
A few of my blog visitors have complained about my
website not working correctly in Explorer but looks great
in Opera. Do you have any suggestions to help fix this issue?


Feel free to visit my blog post :: charlotte north carolina pc repair

Anonymous said...

I have been exploring for a bit for any high quality articles or weblog posts on this
kind of space . Exploring in Yahoo I ultimately stumbled upon this website.
Studying this info So i am happy to show that I've a very just right uncanny feeling I discovered just what I needed. I most no doubt will make sure to don?t overlook this website and give it a glance on a continuing basis.

my blog: business listing sites usa

Anonymous said...

Do you have any video of that? I'd like to find out more details.

Check out my homepage; cartoon t-shirts for girls ()

Anonymous said...

Your style is really unique compared to other folks I have read stuff from.
Many thanks for posting when you've got the opportunity, Guess I'll just
bookmark this site.

Here is my website essays term papers

Anonymous said...

I was recommended this blog through my cousin. I'm now not certain whether this put up is written by means of him as no one else realize such particular approximately my difficulty. You are incredible! Thank you!

my web page - local directory listing

Anonymous said...

Excellent goods from you, man. I've understand your stuff previous to and you are just too great. I actually like what you've
acquired here, certainly like what you're stating and the way in which you say it. You make it entertaining and you still care for to keep it smart. I can't wait
to read far more from you. This is actually a
terrific website.

My web site new business directory list

Anonymous said...

I seriously love your website.. Excellent colors & theme.

Did you develop this web site yourself? Please reply back as I'm planning to create my very own site and would like to find out where you got this from or what the theme is called. Thank you!

Check out my website ... movie discussion questions for les miserables []

hakeem khan said...

Hi. Vishwanath.

Thanks for the usefule Info.

I have exicuted the same comand and able to see the path for the directories but when i go to the same path to see the directories udump, ddump etc unable to see the directories.

Please Help.

Thanks
Hkhan