Enter your mobile number 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.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Buy Used
Condition: Used: Good
Comment: This is a used text in good condition. It may have some writing and highlighting. Ships directly from Amazon. All Supplemental discs, materials, or access codes should be included. Eligible for free super saver shipping.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Oracle Performance Firefighting Perfect Paperback – 2009

4.7 out of 5 stars 12 customer reviews

See all formats and editions Hide other formats and editions
New from Used from
Perfect Paperback
"Please retry"
$65.95 $127.43

The Amazon Book Review
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
click to open popover

New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • 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: #2,135,677 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Charles Hooper on June 25, 2010
Format: Perfect Paperback
This review covers the June 2010 fourth printing of the "Oracle Performance Firefighting" book. I bought a PDF copy of the book direct from the OraPub site. The author's excellent "Forecasting Oracle Performance" book was a factor in my decision to purchase this book, as was my desire to learn something new while trying to maintain previously acquired knowledge. As stated in this book, the author has roughly 20 years of experience working with Oracle Database, worked with Cary Millsap at Oracle Corporation for a period of time, and conducts a successful consulting and training business. I recognize the names of three of the six technical reviewers listed in the book as well known experts in the Oracle community. The author's website states that there are no known issues/errata starting with the third printing (November 2009) of the book. All of the components for the book's success are in place, so how did the book perform?

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 ›
2 Comments 14 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Perfect Paperback
You may all know Tom Kyte, Jonathan Lewis and others as famous speakers and writers about Oracle Internals and Performance troubleshooting.
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.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Perfect Paperback
This book help me to think about oracle and not just read about it, in documentation, white papers, opinions, etc.....
Many time i was just confused when i read about pinning, LRU, MRU, latches, buckets...... This book has the quality, for the first time in my case to present complex alghoritms in a very direct and in a pedagogical way. I am working with Oracle for many years and i wished to have ther chance and read such a book years ago..... Was all so "simple" !. I remember many years of guessing and looking at Oracle with fears and treating it like a black box. I think that all of this was not necessary and made from our challenging profession sometimes a guessing profession. This book changed my way of thinking and burst my knowledeges and capabilities in working with Oracle.
I recommend it to any Oracle professional which tries to understand what happened inside the box and not just using it.
it presents concepts and helps a lot in learning you how to think and solve yourself the problems in the future with a solid background in maths and statistics....
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Perfect Paperback
While researching a particular nasty bug involving In-Memory Undo (IMU), I found a white paper written by Craig Shallahamer that clearly and concisely explained this feature. I was so impressed by the quality of this white paper that I went to his OraPub website to see what else might be available from Craig. I saw that this book had just recently been published, and bought it instantly. I carried it with me to the next NoCOUG conference, and showed it to all who would listen.

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 ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

What Other Items Do Customers Buy After Viewing This Item?