Optimizing Oracle Performance
Publisher: O'Reilly Media
Final Release Date: September 2003
Pages: 416

Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient.

Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes.

Optimizing Oracle Performance eliminates the time-consuming, trial-and-error guesswork inherent in most conventional approaches to tuning. You can determine exactly where a system's performance problem is, and with equal importance, where it is not, in just a few minutes--even if the problem is several years old.

Optimizing Oracle Performance cuts a path through the complexity of current tuning methods, and streamlines an approach that focuses on optimization techniques that any DBA can use quickly and successfully to make noticeable--even dramatic--improvements.

For example, the one thing database users care most about is response time. Naturally, DBAs focus much of their time and effort towards improving response time. But it is entirely too easy to spend hundreds of hours to improve important system metrics such as hit ratios, average latencies, and wait times, only to find users are unable to perceive the difference. And an expensive hardware upgrade may not help either.

It doesn't have to be that way. Technological advances have added impact, efficiency, measurability, predictive capacity, reliability, speed, and practicality to the science of Oracle performance optimization. Optimizing Oracle Performance shows you how to slash the frustration and expense associated with unraveling the true root cause of any type of performance problem, and reliably predict future performance.

The price of this essential book will be paid back in hours saved the first time its methods are used.

Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews


by PowerReviews
oreillyOptimizing Oracle Performance

(based on 3 reviews)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

(1 of 1 customers found this review helpful)


Eye opener for Performance Experts


from Undisclosed

Comments about oreilly Optimizing Oracle Performance:

I came across this book from Tom Kyte's URL and bought it immediately. I am so pleased with myself for choosing this book without a second thought.

As the Authors rightly said, for long long time, i have been working on performance related issues using the dictionary views and statpack. Though attempted to read the tracefile with the help of information from other great books, i never had the comfort of reading and understanding the tracefile this well.

The approach taken by the authors is very much appreciated. The method changes the readers thinking and encourages to see the subject from a different angle (root cause).

Thank you everyone involved in producing this book. I would suggest to all my Oracle friends.



Really Great Reading

By Paul Dyer

from Undisclosed

Comments about oreilly Optimizing Oracle Performance:

It has been quite some time since I had read a tech book cover to cover. This book presents valuable tuning information that has been a long time coming. The information meets my specific needs to solve performance issues in a direct, time-efficient manner. Trial-and-Error is no longer part of my work ethic. With C.Milsap's new tuning methodology, a deteministic approach to Oracle tuning is available for Oracle professionals.

My biggest regret is that I didn't have this information earlier; during the previous 3 or 4 multi-month efforts at tuning long-running SQL batch jobs. Each of my tuning efforts was a success in the end, but not without a significant waste of time using Trial-and-Error, or Intuition-via-Guess.

Also, I would like to thank the author for his work in Queuing Model Theory. Very, very few teachers and writers can deliver a useful and understandable presentation of queuing theory.

(1 of 1 customers found this review helpful)


Optimizing Oracle Performance Review

By Thierry Brouwers

from Undisclosed

Comments about oreilly Optimizing Oracle Performance:

This book is amazing. As a true believer in the methods put forth by Hotsos,

highlighted in various whitepapers available online, and a great admirer of the technical expertise brought forward by all Oaktable members (of which I had the distinct privilege to meet a few), I didn't have to think twice about this purchase. I read it twice cover to cover during one weekend, as the author's enthusiasm really rubs off.

While other books often just list an array of scripts and seemingly random pieces of information to equip the reader with the means to do Oracle performance tuning, this book not only arms you with the technical know-how, but also an inspiring 'can-do' frame of mind plus the author's proven way of tackling performance issues.

Surprisingly, this book is an easy read. But very hard to put down.

If you've heard of Hotsos.com, you've probably got a copy of this book already.

If you haven't, you're in for a treat.

Thierry Brouwers

Freelance OCP Oracle DBA

DB Minded


Displaying reviews 1-3

Back to top

Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $27.99
Formats:  DAISY, ePub, Mobi, PDF
Print & Ebook: $38.45
Print: $34.95