Oracle8 Tuning

by Ian Abramson, Abbott Corey, Daniel J. Dechichio, et al.

This is a comprehensive, authorized treatment of Oracle tuning, written by distinguished leaders in the Oracle community. "Oracle8 Tuning" provides the information database system administrators need... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0078823900
• ISBN13: 9780078823909
• Release Date: October 1997
• Publisher: McGraw-Hill Companies
• Length: 608 Pages
• Weight: 2.76 lbs.
• Dimensions: 1.6" x 7.5" x 9.1"

Customer Reviews

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.

Not an easy read BUT an excellent reference

This is not a book to read straight thru; you don't sit down after dinner and take this up as something to read and refresh your skills. It is a handbook. A book to refer to. A book to use on site at work. In that light it is excellent and the only reason it received 4 stars was I could not download the queries nor did they come with the book on a diskette or some electronic media. I found this to be an unfortunate flaw in an otherwise good cookbook to have on hand.

BEST BOOK / SQL TUNING & PERFORMANCE.

I have purchased many Oracle books but this one is one of the best. Recommended to advance users(DBA/Developer's)...... Very well explained examples, enough detail about the syntax used in SQL tuning. Covers all the important topics of Oracle8 tuning and performance such as partitioning table, Parallel Queries, Explain Plan, TKPROF, SQL Trace and performance pack of Oracle Applications. This is a review from an Oracle Instructor and Consultant.

Oracle DBA's - Get it

Great book!! for anyone who is an experienced DBA.. Useless if you started as DBA yesterday...