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.
-------------------------------
Since you are periodically collecting key business process timing information, gathering the final baseline sample should be trivial. Still, write it down and publish it. Let people know how awesome a job you and your team have done! If performance went from a query taking 12 hours to that query running in 2 seconds, tell them. You don't need to be an egomaniac about it, but at the same time, people need to know they can count on you in the future. Use this opportunity to further instill confidence and hope.
Closely tied to the final performance baseline is documenting your work and its subsequent success. The focus now turns to documenting what just happened to gain a deeper understanding, informing and training others, and to prevent a similar situation from recurring.
When I worked for Oracle Consulting, I required my team to complete an on-site client report, which we called our engagement summary, and distribute it to the entire group. While traveling, we commonly read each other's engagement summaries. This dramatically improved the technical competence of our group. It also created a deep sense of community and camaraderie. When the group is geographically dispersed, as was the case with my team, this is especially valuable to the members.
©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.
|