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
how useful are the dump files?
----- Original Message ----- *From:* Cary Millsap <mailto:cary.millsap@xxxxxxxxxx> *To:* oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx> *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.
**
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------