Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle dumps

Re: Oracle dumps

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Wed, 02 Jun 2004 15:20:05 -0600
Message-id: <40BE4485.9030107@sun.com>


They can be incredibly useful..or incredibly useless. It depends on the knowledge and skill of the viewer, the reason behind reading the dump file, the willingness to test theories. Dump files do not provide quick and dirty answers. There is a great deal of information to wade through, most of it not relevant to what you are looking for.

With some invaluable assistance from a colleague, I was able to read systemstate and processstate dump files to validate a jdbc problem. Since I already had an idea of what the problem was, had retrieved lock and wait information, the information in the dump files was comparable (but much more in depth).

Almost everything I have learned about undo was the result of reading block dumps from very well controlled experiments. I'd venture to say that people who have studied 10046 and 10053 trace files have learned some very advanced concepts from their examination and subsequent thought. There are some things that you cannot find in any other place than a dump file.

Regards,
Daniel Fink

Ryan wrote:
> how useful are the dump files?
>
>
>
> ----- Original Message -----
> *From:* Cary Millsap <mailto:cary.millsap_at_hotsos.com>
> *To:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> *Sent:* Wednesday, June 02, 2004 4:21 PM
> *Subject:* RE: Oracle dumps
>
> Exactly.
>
>
>
> He teaches only rarely, so the problem becomes finding an event
> where hes teaching. But this is an easier problem to solve than
> trying to read block dumps without help.
>
>
>
> **



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jun 02 2004 - 16:17:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US