Oracle Performance Firefighting
by Craig Shallahamer

Get the book here



Craig Shallahamer's Blog

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.
Please—Out 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.
Please—Out 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.


Know what's important before it's too late!

OraPub's
Performance Training

is like no other...





More Class Pics...
Get student testimonials!