You were brought to this page based on an internet search
and as a free service to Oracle DBAs.
The text below is an except from the book,
Oracle Performance Firefighting, written by
Craig Shallahamer of
OraPub, Inc.
Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click
here.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
-------------------------------
When someone is in pain but cannot verbally communicate, diagnosing the problem is difficult. Much like a very young patient, before Oracle instrumented its source code, it was limited in what it could say to us. Finally, Oracle instrumented its source code, and we began listening to it.
Oracle's words may seem strange, but when you've learned what phrases like db file scattered read mean, you will be able to pinpoint the cause of its pain and understand how the flow of information within Oracle was disrupted. In a very real sense, Oracle grew up, and now we can listen to Oracle speak to us like an adult.
Immediately, performance diagnosis takes on a whole new dimension. Instead of inferring where the problem resides and spending countless hours performing diagnosis, our time shifts toward analysis. Wait-event analysis has paved the way to response-time analysis, enabling us to quantify the user experience and develop solutions focused on directly reducing time, instead of increasing efficiency.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
|