Features
- Cover Type: Paperback with 656 pages
- Published by: Wiley
- Edition: 1st Edition August 30, 2002
- Written in: English
- ISBN 10 Number: 0471224367
- ISBN 13 Number: 978-0471224365
-
Book Dimensions:
9.3 x 7.5 x 1.5 inches
- Weighs: 2.7 pounds
Product Description
"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical human being 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 requirements to be addressed right from the design stage, and it requirements 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.
Book Info
Hands-on, 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. Covers both Oracle 8i and Oracle9i. Softcover.
Reader ReviewsWhen 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.
Search for books at
