| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle dumps
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 he’s teaching. But this is an easier problem to solve than
> trying to read block dumps without help.
>
>
>
> **
-- 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
 |
 |