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.
-------------------------------
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.
This chapter starts you off by identifying the keys to thriving in the chaotic firefighting environment, and then introduces the main methods covered in this book. This chapter is about creating the initial framework to prepare you for the eventual firefight. Once the framework is complete, you'll be able to quickly absorb a tremendous amount of technical knowledge, which when methodically applied, yields extremely strong solutions.
Most people around you will be frightened. They will be fighting fires with their right hand, while their left hand is updating their resume on Monster.com. They will be frantically trying to figure out which SQL and programs are consuming a lot of resources, what Oracle processes are waiting for, what users are experiencing, and the CPU consumption-all while people are standing behind them asking for constant updates. What you need is a superior method you trust. There is no way you can or would want to look at every statistic. It's just not possible, and the good news is that it's completely unnecessary. With a proven method, you can take one step forward at a time by gathering the minimum amount of necessary information.
©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.
|