|
 |
|
 |
 |
Optimizing Oracle Performance
|
by Cary Millsap and Jeff Holt
Sales Rank: 295471
|
List Price: $34.95
$22.60
At Amazon

|
|
Paperback: 388 pages
Publisher: O'Reilly Media September 16, 2003
Language: English
ISBN-10: 059600527X
ISBN-13: 978-0596005276
Product Dimensions:
9.4 x 6.8 x 1 inches
Shipping Weight: 1.5 pounds
Product Description
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. This book 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. The price of this essential book will be paid back in hours saved the first time its methods are used.
Customer Reviews & Comments 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.
|
Optimizing Oracle Performance
List Price: $34.95
Available from Amazon
Price: $22.60

| |
|
|
|
|