High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability [Paperback]

Geoff Ingram (Author)

Book Description

ISBN-10: 0471224367 | ISBN-13: 978-0471224365 | Publication Date: August 30, 2002 | Edition: 1

"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues."
-Aki Ratner, President, Precise Software Solutions
Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"-- that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system--not just the database.
High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system.
The book provides practical solutions for:
* Choosing physical layout for ease of administration and efficient use of space
* Managing indexes, including detecting unused indexes and automating rebuilds
* SQL and system tuning using the powerful new features in Oracle9i Release 2
* Improving SQL performance without modifying code
* Running Oracle Real Application Clusters (RAC) for performance and availability
* Protecting data using Recover Manager (RMAN), and physical and logical standby databases
The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.

Editorial Reviews

From the Back Cover

"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues."
-Aki Ratner, President, Precise Software Solutions

Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"-- that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system--not just the database.

High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system.

The book provides practical solutions for:
* Choosing physical layout for ease of administration and efficient use of space
* Managing indexes, including detecting unused indexes and automating rebuilds
* SQL and system tuning using the powerful new features in Oracle9i Release 2
* Improving SQL performance without modifying code
* Running Oracle Real Application Clusters (RAC) for performance and availability
* Protecting data using Recover Manager (RMAN), and physical and logical standby databases

The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.

About the Author

GEOFF INGRAM has spent his entire career in the IT industry, including several years working as a product developer at Oracle Corporation. Since leaving Oracle, he has operated as a freelance consultant for blue chip companies in the banking and telecommunication sectors. He focuses on delivering Oracle systems that meet end-user performance and availability requirements, and has developed a free software application for fine-tuning Oracle applications, available from www.dbcool.com.

Product Details

• Paperback: 656 pages
• Publisher: Wiley; 1 edition (August 30, 2002)
• Language: English
• ISBN-10: 0471224367
• ISBN-13: 978-0471224365
• Product Dimensions: 9.3 x 7.5 x 1.5 inches
• Shipping Weight: 2.7 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #2,679,521 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

4 of 4 people found the following review helpful:

5.0 out of 5 stars Best Oracle book since Tom Kyte's, September 23, 2002

By 

Christopher J. Gait (Nokesville, VA USA) - See all my reviews
(REAL NAME)   

This review is from: High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability (Paperback)

When a medical study discovers that the preliminary results are so positive that it is saving a lot of patients' lives the researchers will stop the study to publish preliminary results and get the word out. I haven't finished reading this book. In fact I just got it last week and am only about 100 pages into it. But already I am convinced that this is the best Oracle book in recent memory. It is well written and extremely informative. The format steps a beginner through step by step, and along the way shows the intermediate and advanced Oracle DBA some very important fine points.

The title is a bit deceptive, in that although it certainly is a performance book, the approach is to build the RDBMS application from the ground up with good performance as the ultimate goal. This is the right way to go about getting good performance, as opposed to the crisis management approach applied to legacy systems after the fact. Most legacy applications that performance tuning experts see in the field have a hideous design created by people who no longer work with or for the company and, judging by the implementation, are currently in hiding, hoping that no one can trace the code to them. But if someone were to set up their database by using this book, step by step, it would be a pleasure to tune, though it probably wouldn't need it. There is a great chapter on Data Guard (standby database), and a lot of material that is obviously drawn from years of hands-on day-to-day work with the Oracle RDBMS 'in the trenches.' In short, buy this book, it's worth the money.

1 of 1 people found the following review helpful:

5.0 out of 5 stars new approach may annoy old school DBAs, February 1, 2003

By 

Meredith Fox (San Francisco) - See all my reviews

This review is from: High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability (Paperback)

i love this book! It's maybe the first book to cover the end to end management of Oracle completely not just the server, in a modern way. Oracle brags about how admin is easier these days and this book shows why it's true. But there should be a warning on the cover. Old school DBAs who spend lots of time on row chaining, microplacement of database files, fragmentation, STATSPACK (which is covered) for performance etc won't like it. I finally ditched tar and dd for backups and started using RMAN based on the RMAN chapter in this book. I just wish i'd done it years ago, but i guess I was stuck in denial. If you want your eyes opened on how to manage Oracle in the future not the past buy this book!

1 of 1 people found the following review helpful:

5.0 out of 5 stars The most 'REAL' Oracle book in sometime, September 26, 2002

By 

Mr Mark Clark (Suffolk United Kingdom) - See all my reviews

This review is from: High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Availability (Paperback)

Having spent many years in the Oracle industry its suprising how many mediocre books find their way onto bookstore shelves.

This item however, covers everything in a most comprehensive and realstic fashion, dispelling the many myths about Oracle database admin work, but more importantly all the non-DBA activities and essentials that people frequently ignore or overlook.

A works, that is without doubt based on many years practical field experience, fencing with both sys admins and application developers alike.

It covers virtually every element of making Oracle systems work in the real world and even manages to touch on Linux/RAC and Standby systems.