Oracle8 Tuning

Book Description

Fine tune your Oracle8 database for maximum performance and productivity./p>

Reviews From AMAZON.COM

Complete coverage of tuning for new & experienced DBAs

There is a wealth of information in this book for both new and experienced DBAs. For the new DBA the book presents a panoramic view of database tuning that begins with installing a new instance, coverage of each facet of tuning, and putting it all together as a holistic approach. Experienced DBAs will probably discover that they already know most of the techniques; however, having them collected in a single book that systematically addresses each facet of the tuning process makes for a useful reference.

What I especially like about this book is the collection of rules that are on almost every page. These would have been even more useful if they were repeated in an appendix and cross-referenced to the chapters in which they appear. This would allow DBAs to skim through the rules, then jump to the applicable chapter and drill down into the details. I also like the chapter on Other Database Issues. Even experienced DBAs will discover something new in that chapter.

Some parts of book are irritatingly redundant - the authors state a rule or fact, then restate it again a few paragraphs later. This does not, in my opinion, diminish the overall value of the book, although it can slow you down when you're concentrating on a specific topic.

I found that the best way to read this book for maximum benefit is to do a pass from start to finish with a yellow highlighter. This approach allows you to tag information that may be new to focus upon during the second pass through the book. Also note that the book is true to its title - it thoroughly covers tuning, but only touches upon capacity planning, which is closely related and often included in similar books. This is not a criticism of the book (after all, the title is accurate), but to inform potential readers of what's actually covered.

Excellent Book for Performance Tuning

Great buy, we improved processing time by 40%, many new techniques for setting up initialization parameters and SQLs.