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.

-------------------------------

* Recommendations: Most people will ask for a consolidated recommendation list. While this list may be more detailed in subsequent sections and summarized at a high level in the Executive Summary section, in the Recommendation section, keep this list succinct, like a simple check box list. This also serves as a follow-up reference; that is, a kind of baseline.

* Performance Summary: In a single sentence, summarize each subsystem's situation and comment on their relationships. Then clearly and forcefully establish the relationships among the three subsystems. In each subsystem's Performance Analysis section, I focus primarily on that circle's area. But in this Performance Summary section, my goal is to clearly demonstrate that their activity is strongly correlated. If I can establish these links, my recommendations will not only attack the actual problem, but will also be better received by others. I also summarize my recommendations in this section, showing how they address the problems directly.

* Oracle Performance Analysis: Start this section with a one- or two-sentence summary of the Oracle performance analysis. Then focusing on Oracle, not the application or the operating system, perform a detailed Oracle response-time analysis (you'll learn more about how to do this later in this chapter and in Chapter 5). This section is very detailed and includes actual script output and screen shots.

©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!