Automotive Holiday Deals Books Holiday Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Adele egg_2015 Fire TV Stick Beauty Deals Gifts Under $50 Amazon Gift Card Offer minions minions minions  Amazon Echo Starting at $84.99 Kindle Black Friday Deals BestoftheYear Shop Now Tikes
Optimizing Oracle Performance and over one million other books are available for Amazon Kindle. Learn more

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.

  • Apple
  • Android
  • Windows Phone
  • Android

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

Optimizing Oracle Performance

32 customer reviews
ISBN-13: 978-0596005276
ISBN-10: 059600527X
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$5.50 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$27.28 On clicking this link, a new layer will be open
More Buying Choices
39 New from $19.23 50 Used from $0.01
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Best Books of the Year So Far
Looking for something great to read? Browse our editors' picks for 2015's Best Books of the Year in fiction, nonfiction, mysteries, children's books, and much more.
$27.28 FREE Shipping on orders over $35. Only 4 left in stock (more on the way). Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • Optimizing Oracle Performance
  • +
Total price: $50.21
Buy the selected items together

Editorial Reviews

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 (, 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.


Hero Quick Promo
Holiday Deals in Kindle Books
Save up to 85% on more than 1,000 Kindle Books. These deals are valid until November 30, 2015. Learn more

Product Details

  • 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: 4.6 out of 5 stars  See all reviews (32 customer reviews)
  • Amazon Best Sellers Rank: #904,834 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful By A Customer on February 17, 2004
Format: Paperback
It's surprising how often people say things without knowing what they're talking about. That's a good, short description of almost everything that's been said about Oracle tuning over the last 15 years.
Surprisingly, the facts about tuning Oracle are pretty simple. Most of the results you will achieve come from doing one thing -- tuning individual SQL statements.
The author of this book is one of the few Oracle experts around, and he has created a product called HOTSOS, which is essentially an enhanced version of TKPROF. At times this book reads like the world's best infomercial, designed to promote the author's product.
Still, 99% of Oracle professionals will benefit from this book, even if you don't buy the author's product. It explains very clearly how to DIAGNOSE Oracle performance problems, and it shows an entire approach to tuning that's invaluable.
By the way, there's absolutely no need to know calculus or any other advanced math to understand this book. This rumor apparently got started by some blowhard, pretending to be an expert, but mainly interested in self promotion and telling the world, "I know calculus!" In fact, anyone with basic knowledge of SQL could understand this book and benefit from it.
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
12 of 12 people found the following review helpful By Robert G. Freeman on September 26, 2003
Format: Paperback Verified Purchase
In a style that will be appreciated by the beginner, intermediate and advanced DBA/Developer, Cary and Jeff introduce the reader to the world of the Oracle wait interface. This book has depth, the contents are full of meat, and it's not a rehash of every other Oracle book published in the last 10 years. In these pages is something for everyone. Cary introduces the wait interface, and how it can be used for tuning. The book presents the topic in a clear and concise fashion.
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!
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
9 of 9 people found the following review helpful By Kireet M Reddy on March 24, 2004
Format: Paperback
This book is a great starting point for beginners (like myself) or a good reference for even experienced Oracle DBAs. It is just what you would expect from an O'Reilly book, it is very readable and presents information in a logical manner. It is refreshing to finally find a book about Oracle performance that does more than provide a collection of "tips" that you can try and then cross your fingers hoping it will improve things. I enjoyed this book thoroughly and it will definitely stay in my library.
I give it only 4 stars instead of 5 because of a couple reasons.
1. The author really pushes his hotsos profiler, which I don't mind too much. What did bother me a little bit is that in his case studies and any time showed "Method R" in action, he used the output of the profiler as a starting point. It would have been nice to assume the reader is not going to purchase the profiler and proceed from that point instead of always starting at the resource profile which the profiler outputs. This is a little nitpicky I admit.
2. I would have liked to see an expanded section on seeing Method R in action, or even downloadable sql scripts that you could run on a database and then find the bottleneck in its execution.
Overall, I definitely would recommend this book. It is well worth the money and time.
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
15 of 17 people found the following review helpful By Niall Litchfield on October 22, 2003
Format: Paperback
If you want a quick checklist of whats wrong with your Oracle systems - do not buy this book.
If you want validation of your existing tuning techniques - so not buy this book.
If you want to be told what to do without thinking - do not buy this book.
If on the other hand you are fed up with received wisdom that does not work, you recognize that performance tuning is a valuable skill for your business and you wish to learn an effective scientific and repeatable approach to improving the performance of your business systems, don't just buy this book but live it. Cary and Jeff take a rigorous, scientific approach to performance tuning that is especially suited to Oracle systems and by both formal proof and real world example show that the mystery of Oracle performance is controllable by you.
The only downside comes from explaining to your boss that the thousands you spent on automated performance tools were wasted.
A word about the Math. 2/3 of the book has no math at all in it. The remainder of the book was perfectly understandable to this reader, whose academic background is Economics and Philosophy not maths or computer science. Don't be put off by the idea that the book has equations, a competent High School student can follow the relevant mathematical arguments.
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
7 of 7 people found the following review helpful By George A. Loewenthal on December 6, 2005
Format: Paperback
I purchased this book and did not open it for about 4 months. After reading the first 25 pages or so I became motivated to read more and finish it. It took me about 2 weeks to read through the entire book. The author does a really good job of detailing how to use Oracle tracing to troubleshoot performance related issues. With no shortage of Oracle performance tuning books this is definitely one of the better ones. This book must be one of the best performance related books because you can read it cover to cover. The book is packed with detail so you will reread several pages a few times, kind of like being in college and spending a couple of hours reviewing a couple of pages out of Calculus book.

If you are at all serious about becoming better at Oracle tuning this is a great book to read.
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

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Optimizing Oracle Performance
This item: Optimizing Oracle Performance
Price: $27.28
Ships from and sold by

Want to discover more products? Check out this page to see more: oracle certification