- 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,300,179 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.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
"Rebound" by Kwame Alexander
Don't miss best-selling author Kwame Alexander's "Rebound," a new companion novel to his Newbery Award-winner, "The Crossover,"" illustrated with striking graphic novel panels. Pre-order today
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
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.
Author interviews, book reviews, editors picks, and more. Read it now
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Some difficult material that is covered with detailed and simple explanations. If you can read and follow through with the examples you will definately come to understand even these parts.
The gaps Millsap and Holt create in other Oracle performance tuning books are 'assumptions', 'generalizations' and 'inaccuracy' because this book teaches the reader how to precisely identify user's Oracle performance problems, and exactly what to fix.
Having read this book in depth, I'll continue by saying this book also shows how to fix Oracle Performance problems. But, I almost guarantee if you are not prepared to learn the material, and follow the Method R, you may disagree this book shows 'how'.
This book is five stars because its the only reference currently available (first of class in my opionion) that provides 100% business value to Oracle performance tuning of existing systems (Oracle 7 through 10). Experience Oracle DBAs and Developers may have problems with this book because it will cause you to think about Oracle Performance in a new, refreshing way by directly improving user's response times.
Hopefully, you will read this book with an open mind and capture why Method R is so powerful to solve all sorts of Oracle performance tuning problems. Great job Millsap and Holt.
The book is written in a style which is enjoyable, scattered through with "war stories" and experiences which illustrate good points.
This book is not just another script book. The author not only shows you how to tune using his method but also explains why that method works. There are complex calculations included in the descriptions but it is not necessary to know higher math to use this process. No matter what method you use for tuning SQL and Oracle instances, there is material in this book which will enhance your understanding and your tuning toolkit.
I'm going to have to read it at least twice to fully-appreciate it, and I fear that some of the theory will not apply to my systems.
The only objestion I saw is that there was very little material on solutions, and the book focus is on finding issues, with not enough about how to fix the problem. Other than that, I was satisfied and commend the author for writing what surely must be the most theoretical and mathematical Oracle book anywhere.
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!
Cary Millsap worked at Oracle for 10 years on system performance before co-founding Hotsos in 1999 [...]. He is one of the most trusted sources on matters of Oracle system performance, and "Optimizing Oracle Performance" is considered his finest work (4.5 out of 5 stars on Amazon). The best way to learn more about him is to see for yourself. Here are some of his most popular articles:
"Diagnosing Performance Problems" from Oracle Magazine. A brief summary of what is covered in this book[...]
"Introduction", the first chapter from "Optimizing Oracle Performance."Chapter 1: [...]
"Case Study", the 12th chapter from "Optimizing Oracle Performance."Chapter 12 (Case Study): [...]
"Performance Management: Myths and Facts." One of his most popular articles.[...]
"Why a 99%+ Database Buffer Cache Hit Ratio is Not Ok." Another of his more popular articles.[...]
While everyone will have their own favourite parts of the book, I think most readers would agree that getting a good taste of the author's performance tuning philosophy is one of the highlights. "Method R", not to be confused with "System R" (ie. SQL), is not about looking at STATSPACK, cache hit ratios, or V$ tables and guessing. The author wanted to devise a system to identify and resolve the top performance concerns of an organisation with reliable, predictable results. The first few chapters put this method in writing in perhaps the best way since the introduction of "YAPP" (Anjo Kolk).
"The performance enhancement possible with a given improvement is limited by the fraction of the execution time that the improved feature is used." - Amdahl's Law
After several years of research, the author discovered that Extended SQL Trace Data was at the centre of "Method R". Some of the articles should give you a good taste of what Extended SQL Trace data is, if you didn't know already. By the time you finish reading this book you will know exactly how to collect and interpret all the little "ela=17101 p1=10 p2=2213 p3=1 ..." within into something meaningful. For some, that justifies the price tag right there.
So in essence I would have re-named this book "Method R: Optimizing Oracle Performance Using Extended SQL Trace Data," because that is basically what this book is about. There are some reasonably "stand-alone" chapters on other topics, for instance on the Oracle Fixed View tables (Chapter 8) and on Queueing Theory (Chapter 9), but that is not the primary focus of the book.
Those that are expecting a more broad treatment of the subject of performance tuning may be justifiably disappointed that it basically covers only this narrow aspect. However, it is covered very well, and it isn't really covered anywhere else. The author makes no apologies for this, claiming that extended SQL trace data is the only resource you will ever need for diagnosing and solving performance problems.
"You cannot extrapolate detail from an aggregate." - Cary Millsap's preference of SQL extended trace data over fixed views (system-wide average performance characteristics)
Indeed, some people might contend that the author spends a little too much time stating his beliefs, defending them, and patting himself on the back. But I think it adds a certain flavour to the book, and I respect an author who backs up his statements.
"Proving that V$ data are superior to extended SQL trace data because of the 'missing time' issue is analagous to proving that its safer to be in a room with a hungry bear if you'll just close your eyes." - Cary Millsap
The book can be a tough read in the sense that the author goes very deep into the material, and generally each subject is treated thoroughly. Chapter 9 on Queueing Theory can be a particularly overwhelming chapter. But the material is served in bite-size pieces, and broken up with tips, tricks, stories, diagrams and code (sometimes 3+ pages worth at a time, embedded directly in the middle of a chapter). There are even worthwhile exercises at the end of each chapter.
In the end, I enjoyed this book and I'm glad I got it. I don't consider it a "must have" for your Oracle collection, but I definitely feel it is quite worthwhile. I recommend it especially to those who read his articles and were very comfortable with his writing style and philosophy, and also to those that need a book on extended SQL trace data (because this is basically the only one). But even those in the "Silver Bullet" camp will be glad to add another tool to their belt.
Most recent customer reviews
Although the author's beautiful explanation of 10046 traces and...Read more