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@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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: