- Paperback: 388 pages
- Publisher: O'Reilly Media (September 26, 2003)
- Language: English
- ISBN-10: 059600527X
- ISBN-13: 978-0596005276
- Product Dimensions: 7 x 1 x 9.2 inches
- Shipping Weight: 1.5 pounds (View shipping rates and policies)
- Average Customer Review: 32 customer reviews
- Amazon Best Sellers Rank: #1,373,916 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 mobile phone number.
Optimizing Oracle Performance: A Practitioner's Guide to Optimizing Response Time
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
About the Author
Cary Millsap is the former Vice President of Oracle's System Performance Group and the cofounder of Hotsos, a company dedicated to Oracle system performance. Hotsos provides performance-improvement tools for Oracle environments and also delivers training in the form of clinics and symposiums. Cary is also a founding member of the Oak Table Network (http://www.oaktable.net), an informal association of "Oracle Scientists" well known throughout the Oracle community.
Jeff Holt is one of the world's most productive Oracle performance optimization specialists. He has tremendous experience in constructing training programs and software tools to optimize the system performance management process. He is a former support analyst and consultant at Oracle Corporation, where he served as a technology leader in the System Performance Group. He is the Hotsos Tools lead designer and developer, the author of several technical papers, a Hotsos founding employee, and a Hotsos Clinic principal developer.
Browse award-winning titles. See more
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Missteps are, in my experience, (1) too much Markovian queuing theory and formulas --discrete event simulation with real world distributions is far more practical (2) no guidance on what to do when you've "maxed out" your existing configuration... add more CPU? more disk? dunno.
I've had this book on my shelf since 2004 beside Tom Kyte's Expert Oracle: Signature Edition (Expert One-On-One). Both are essential classics for the Oracle practitioner.
The book is full of detail such as concise information on the internal workings of Oracle trace files and how to use them to your advantage when tuning your Oracle database. They demonstrate the power of the 10046 event and it's potential.
Putting all of this together into a performance tuning method he calls Method-R, they lead us from tuning by guess work into a world of facts and using accurate measures to generate appropriate tuning responses.
This book IS required reading for any DBA who wants to be elevated to the level of a tuning deity. I've already dog eared a goodly number of pages!
It has highlighted a lot of very useful techniques to ensure you focus on the true problems, and not the various ratios we've taken as absolute truth for so many years. I can't wait to try these concepts out!
Although the author's beautiful explanation of 10046 traces and waits are worth its weight in gold, much of the information could have been condensed into fewer pages. Regrettably, most of the book are fillers. The author tries to explain much of his thoughts in mathematical formuls (nothing difficult) but it didn't add to the comprehension of the topic.
One thing which made this book stand out was the problems and exercises at the end of each chapter. They were helpful, and unique among Oracle books, in enabling the reader to understand the topic more thoroughly.
Overall, I recommend this book. But I have read better, and more comprehensive, books on the Oracle performance.
After dusting-off my 1970's Calculus texts (thank God I took 4 semesters of Calculus), I was able to start this epic tome.
This is not an easy read! While not quite as slow as reading Ulysses (James Joyce), expect to spend many hours digesting and understanding the mathematical equations and concepts in this text.
For those with the appropriate College-level background (A Masters in Computer Science or Electrical Engineering), the book is wonderful (or so I'm told, I'm just an MBA).
Packed with queuing theory and advanced CS concepts, Millsap does a wonderful job applying the CS theory with the operational working of Oracle, especially with respect to wait event analysis.
The section of using SQL*trace and 10046 trace files are the hallmark of the Millsap approach, and Cary has done a wonderful job explaining this is plain English, with lot's of references to the v$ structures.
The only shortcoming of this book is that it may be too advanced for marginal Oracle professionals who do not possess the appropriate math and statistics background to appreciate the illustrations.
With respect to technical accuracy, the book is well annotated and researched, and the only issue I found was that Millsap's explanation of the pdf Poisson distributions were "fishy". (Sorry, I couldn't resist!)
Otherwise, this is an outstanding technical resource, worthy of the practicing Oracle database administrator.
Most recent customer reviews
Cary Millsap and Jeff Holt were scientists at Oracle and now in their own company.
The books has three parts.Read more