- Perfect Paperback: 406 pages
- Publisher: OraPub, Inc.; 4th edition (2009)
- Language: English
- ISBN-10: 0984102302
- ISBN-13: 978-0984102303
- Product Dimensions: 8.8 x 7 x 1 inches
- Shipping Weight: 1.5 pounds
- Average Customer Review: 4.7 out of 5 stars See all reviews (12 customer reviews)
- Amazon Best Sellers Rank: #3,368,250 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
Oracle Performance Firefighting Perfect Paperback – 2009
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Customers Who Viewed This Item Also Viewed
More About the Author
Top Customer Reviews
There are definitely positive moments in the book, where the book successfully communicates complicated topics using very clear statements. The book publisher selected a font size and margin size that packs a significant amount of detail into each of the book's 387 pages. There are several well-placed helpful diagrams with no space wasting cartoon drawings. The author introduced his three circle analysis which involves identifying the intersection of the Oracle Database, the Application, and the Operating System to help pinpoint the source of performance problems. Several examples were provided where the author used the Linux strace command to troubleshoot Oracle Database performance problems. The book recommends against modifying the _SPIN_COUNT hidden initialization parameter, which is a wise advisement.Read more ›
Craig may not be as famous as they are but its "Oracle Performance Firefighting" Book is probably so far the best book written about Oracle internals & Performance troubleshooting.
It's all about correlating Application, Operating system and Oracle Engine in order to understand where the bottleneck is located and what you should do in order to solve it.
Craig provides the very strong "3 cricles" global approach which can be applied to any Oracle performance issue and also delivers the most complete description about Oracle internals and how by understanding them you can move forward with your performance troubleshooting challenge. Just as an example, Craig does not simply describe how latches and mutexes work, He also provides practical solutions to solve any kind of latch contention you can experiment. Definitly the most comprehensive book written on a very touchy topic.
Craig has written a practical, informative, and very clear book that integrates important Oracle performance and scalability topics with valuable communication and problem solving advice. His lively explanations of latching, wait events, the buffer cache, the shared pool, and redo mechanisms alone are worth the price of the book. Combined with excellent communication tips, a foundation of queueing theory, real-world examples, and a freely available toolkit, this book is truly invaluable.
At the core of this book are explanations of important Oracle internals, especially latching, the wait interface, the buffer cache, shared pool, and redo mechanisms. Craig delves into the internals with just enough detail to enable practical problem solving, while completely avoiding any unnecessary detail. Craig's simple analogies and clear graphics greatly enhance readability. For example, his lively analogy for Oracle's general latching mechanism is both useful and unforgettable, a true classic! Craig explains Oracle's wait interface with a unique analogy involving application programmers who want to add instrumentation to their own code; this perspective is very accessible for newcomers to the wait interface, and provides insight even to experienced users.Read more ›
Beyond a means for accurate diagnosis, Oracle Performance Firefighting describes a way "telling the story" to stakeholders. This can be as important as identifying where the problems exist. Craig provides the steps he has used many times in the real world. It starts with separately documenting metrics from the application, operating system, and Oracle itself. These detailed working documents typically contain actual diagnosis script output. Information from the detailed analysis documents is then captured into Performance Summary in which each subsystem's situation is described along with their relationships. The final two steps for telling the story are presenting Recommendations and an Executive Summary. The Executive Summary "introduces the entire exercise and sets the stage so anyone can understand the importance of your task".
In addition to the softer side performance management strategy, Craig is no stranger to Oracle internals and why they matter. He has leveraged their deep understanding, combined with years of teaching and consulting through the OraPub enterprise, in the creation of Oracle Performance Firefighting.
Most Recent Customer Reviews
This book was, I am sorry to say, something of a disappointment.
I was expecting it to offer some insights and fast tracks to diagnosing and fixing Oracle performance... Read more
Professor Shallahamer's book is AWESOME! It presents a new way of structuring the analysis of Oracle database trouble-shooting and problem-solving. Read morePublished on May 7, 2012 by AOKEKE
This book consolidates the essential internals in a very interesting style.
The amount of insight provided is simply spectacular. Read more
This book help me to think about oracle and not just read about it, in documentation, white papers, opinions, etc..... Read morePublished on July 2, 2011 by Adrian Sperlea
I tend to choose my books fairly carefully. With the amount of information that is out there on the web for free, there's a lot more competition for my training dollars, and as an... Read morePublished on June 15, 2011 by D. King
For those looking for a clean word.
Fascinating book in which Craig clearly explains complex oracle topics.
Perfect work, Craig.
This book is one of the best regarding oracle performance and oracle internals.
There's a lot of information about oracle internal structure and the entire book is written in... Read more