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


See all formats and editions Hide other formats and editions
Amazon Price New from Used from
Perfect Paperback
"Please retry"
$65.95 $127.94
Best%20Books%20of%202014
NO_CONTENT_IN_FEATURE

Image
Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at Audible.com. If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at ACX.com.

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,788,909 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.7 out of 5 stars
5 star
10
4 star
0
3 star
2
2 star
0
1 star
0
See all 12 customer reviews
Definitly the most comprehensive book written on a very touchy topic.
Olivier Bernhard
Combined with excellent communication tips, a foundation of queueing theory, real-world examples, and a freely available toolkit, this book is truly invaluable.
David M. Abercrombie
This book provides the Oracle performance practitioner a time tested performance management strategy.
gco

Most Helpful Customer Reviews

13 of 16 people found the following review helpful 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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By R. ARMSTRONG-FINNERTY on August 14, 2014
Format: Perfect Paperback
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 issues, with pearls of wisdom, based upon the author's experience and skills, dropping from every page.

In reality, the book is a mishmash of decent explanations of such things as latching, CPU queuing, the redo mechanism, and other such stuff; some interesting scripts to view what's going on in the database; and a lot of filler material towards the end, where fire-fighting is replaced with (what seems to be the author's pet subject) performance prediction.

I found it distinctly odd that explain plans were not mentioned once - in a performance troubleshooting book? I didn't get a real sense of systematic problem-solving in this book; rather, a jumble of "how-tos". It's also worth mentioning that Oracle Enterprise Manager's system/database statistics presentation makes much of the book's teaching of sar, vmstat, v$osstat, and so on, redundant.

The author uses strange phrasing, which is distracting, such as, "If you ever see system time surpass user time, either contact your system administrator or casually give your pager to your colleague and walk away". Not the sort of "tip-toe away and hide" antics one would expect from any DBA, particularly a fire-fighting heroic one!

In a real-life Oracle database fire-fighting scenario, I would not be reaching for this book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By D. King on June 15, 2011
Format: Perfect Paperback
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 independent consultant who pays for my own training and reference materials, value-for-money is top priority.

With Craig's book, I knew what to expect - evidence based and real world examples of Oracle performance problems. I had been reading whitepapers by Craig (OraPub) online for years, and was lucky enough to attend a course he ran in Toronto a few years ago - it was easily the best money I had ever spent.

The Oracle Performance Firefighting book really opened my eyes to a lot of the internals that determine how much performance you're going to be able to squeeze out of your database. Some of those "rules of thumb" that you always hear are explained (or disproved). Things that I *thought* I understood were explained to levels not seen in any Oracle documentation, and things that were new to me were presented with lots of examples, diagrams and show-and-tell type experiments. If you've read any of Tom Kyte's books or postings you it's a similar style.

I think what I like most about this (and his other books) are the strong foundation in math that all of his conclusions are based in. The fundamentals of performance are explained in a way that both makes sense, and can be experimentally proven. You are walked through each step in identifying, classifying, and resolving the most common performance problems you'll see.

In summary:
- great author
- interesting and applicable examples
- clear and concise writing

I have bought this book for myself, and several of my customers.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By jagodeugrlu on June 14, 2011
Format: Perfect Paperback
For those looking for a clean word.
Fascinating book in which Craig clearly explains complex oracle topics.

Perfect work, Craig.
Well done.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews