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.
-------------------------------
4 For SQL tuning help, I turn to Mr. Mark Gury of Mark Gury & Associates (MGA) based in Melbourne, Australia. Mark makes his living, in large part, by tuning the biggest and baddest SQL statements I have ever seen.
Firefighting situations are unique in that they contain a number of elements, which together bring fear and panic to nearly everyone involved. What you need to excel in this environment is confidence to methodically move forward step by step. Even though people are out of control around you and you're being peppered with distractions, if you have a proven method, you'll know exactly what to do. This book provides the knowledge and methods you need to be successful in a firefighting situation.
If you scan this book, you will notice a few recurring themes, such as OraPub's 3-circle analysis method, wait-event analysis, response-time analysis, and a solid understanding of Oracle internals. The beauty of these is that each supports the other during diagnosis, analysis, and communication, leading to building an extremely strong solution case and breeding cooperation.
©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.
|