Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry.
> Shop now
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 ›
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.
Professor Shallahamer's book is AWESOME! It presents a new way of structuring the analysis of Oracle database trouble-shooting and problem-solving. I was able to put the OraPub 3-Circle Analysis method to use immediately to solve a long-standing disk i/o problem. We thought the problem was with the SAN, but it turns out the problem was both in the SAN configuration AND the database configuration. When you're under great stress and pressure to resolve a production database problem, you need to have a proven and methodical plan to stay cool and resolve it while others are panicking.
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....