Oracle8 Tuning (Oracle Press Series) [Paperback]

Abbott Corey (Author), Daniel J. Dechichio (Author), Michael J. Corey (Author), Michael Abbey (Author), Ian Abramson (Author)

Book Description

Publication Date: October 30, 1997 | ISBN-10: 0078823900 | ISBN-13: 978-0078823909 | Edition: Authorized

This volume provides the information database system administrators need to customize the Oracle8 database system to the specific needs of its users. Readers learn strategies and systems to avoid problems, increase database speed, and ensure overall security. They'll also learn the basics of improving Oracle's performance, as well as how to use its tools and networking capabilities. The authors discuss optimization for DEC, SUN and other popular platforms.

Editorial Reviews

From the Back Cover

Get Optimal Performance from Your Oracle Database.

In today's world of mission critical database systems, milliseconds mean money. High-level performance tuning skills are in great demand. Oracle8 Tuning is packed full of these career-enhancing skills and carries the official endorsement of Oracle Corporation.

Using actual application and technique examples from companies with precisely tuned and customized Oracle Server environments, four of the Oracle community's most respected experts show you how to:

• Become proactive in your Oracle tuning efforts
• Customize an Oracle database to fit your organization's mission-critical demands
• Use Oracle8's new tools and networking capabilities to create a smarter, more efficient database system
• Address the performance issues of all platforms including Microsoft's Windows NT and Hewlett-Packard's HP/UX
• Tune I/O, memory, CPU power, security, and more for maximum performance
• Tailor your system with Oracle tools, such as Oracle Enterprise Manager, PL/SQL, and the Performance Pack
• Maintain optimal performance levels with tried-and-true tips on troubleshooting

Oracle8 brings with is a slew of new technology just waiting to be tuned, tweaked, and customized. No other book gives you more information on getting the best possible performance from your Oracle database system than Oracle8 Tuning.

Product Details

• Paperback: 608 pages
• Publisher: Osborne Publishing; Authorized edition (October 30, 1997)
• Language: English
• ISBN-10: 0078823900
• ISBN-13: 978-0078823909
• Product Dimensions: 9.1 x 7.4 x 1.5 inches
• Shipping Weight: 3 pounds
• Average Customer Review: 3.7 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #5,393,869 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

9 of 9 people found the following review helpful:

4.0 out of 5 stars Not an easy read BUT an excellent reference, June 1, 2000

By 

Georgina "tville" (san francisco, ca) - See all my reviews

This review is from: Oracle8 Tuning (Oracle Press Series) (Paperback)

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.

9 of 9 people found the following review helpful:

5.0 out of 5 stars Excellent Book for Performance Tuning, February 20, 2002

By A Customer

This review is from: Oracle8 Tuning (Oracle Press Series) (Paperback)

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

1 of 1 people found the following review helpful:

5.0 out of 5 stars Complete coverage of tuning for new & experienced DBAs, July 18, 2002

By 

Mike Tarrani "www.tarrani.com" (Deltona, FL USA) - See all my reviews
(COMMUNITY FORUM 04)    (REAL NAME)   

This review is from: Oracle8 Tuning (Oracle Press Series) (Paperback)

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.