Oracle Performance Tuning, Second Edition

By Mark Gurry, Peter Corrigan
November 1996
Pages: 964
ISBN 10: 1-56592-237-9 | ISBN 13: 9781565922372
(4) (Average of 6 Customer Reviews)

Book description

The first edition of this book became a classic for developers and DBAs. This edition offers 400 pages of updated material on Oracle features, including parallel server, parallel query, Oracle Performance Pack, disk striping and mirroring, RAID, MPPs, SMPs, distributed databases, backup and recovery, and much more.
Full Description

The books in O'Reilly's Oracle series are authoritative -- they tell the whole story about complex topics, ranging from performance tuning to the use of packages in PL/SQL to new technologies like Power Objects. And they're independent; they're alternatives for readers who need to know how products and features really work. They're packed with real-world advice and techniques from practitioners in the field, and they come with disks containing code you can use immediately in your own applications. O'Reilly is the alternative for Oracle people who need to solve problems -- and solve them now. Performance tuning is crucial in any modern relational database management system. Too many organizations respond to Oracle performance problems by throwing money at these problems -- by buying larger and more expensive computers or by hiring expert consultants. But there's a lot you can do on your own to increase dramatically the performance of your existing system. Whatever version of Oracle you're running -- from Version 6 to Oracle8, proper tuning can save your organization a huge amount of money in additional equipment, extra memory, and hardware upgrades. The first edition of Oracle Performance Tuning became a classic for programmers, managers, database administrators, system administrators, and anyone who cares about improving the performance of an Oracle system. This second edition contains 400 pages of updated material updating on Oracle features, incorporating advice about disk striping and mirroring, RAID, client-server, distributed databases, MPPS, SMPs, and other architectures. It also includes chapters on parallel server, parallel query, backup and recovery, the Oracle Performance Pack, and more.

Post-purchase benefits:

Browse within this book

| Table of Contents | Index | Sample Chapter | Colophon

Book details

Second Edition: November 1996
ISBN: 1-56592-237-9
Pages: 964
Average Customer Reviews: (4) (Based on 6 Reviews)

Featured customer reviews

Oracle Performance Tuning, 2nd Edition Review, May 12 2001

Rating:

Submitted by Alan Wilson [Respond | View]

Reading this book has greatly increased my knowlege of how Oracle databases

work and how to tune them. I used the book to help me study for the OCP tuning exam. This book is a masterpiece but a new edition is needed to bring the book upto date for Oracle8i.

Oracle Performance Tuning, 2nd Edition Review, January 03 2001

Rating:

Submitted by K Vainstein [Respond | View]

The book is certainly excellent, but its being outdated is a very serious minus. Since 1996,

many INIT.ORA parameters have been dropped
recommended OFA (alluded to) has been changed quite a bit
hardware landscape has changed, a lot. Disk is dirt-cheap, local storage networks are the latest fad. There're some new RAID types and filesystems
Web browsers are the most common clients; correct interaction with web servers (eg, staggered connection acquisition) is important
using the cost-based optimizer is almost always the Right Thing, due to improvements
many new index features/choices (and we all know how important indexes are!)
new Oracle add-ons like interMedia and iFS can use some honest performance evaluations

, and so forth...

In other words: a new edition is imperative!

PS: As to archiving being "not recommended", that's a pretty nuts piece of advice in this day of 24-7 HA being a routine requierment. Having your DB down with no backup is what I do not recommend.

K "V" Vainstein <v@musecorp.com>

Oracle Performance Tuning, 2nd Edition Review, December 08 2000

Rating:

Submitted by Marcus Vinicius Ferreira [Respond | View]

Excellente book!

This book opened my eyes for the fact that performance tuning goes beyond SQL code and hardware: it is also about OS, SQL*Net, Backup&Recovery, standards and so on.

When will the next edition be available ???

Marcus

Read all reviews

Oracle Performance Tuning, 2nd Edition Review, November 16 2000

Rating:

Submitted by Wayne Vieira [Respond | View]

This book is in a league by itself, a must have for Oracle DBA's. I have read a lot of Oracle performance tuning manuals but none come close to matching this book. We need a 3RD edition with more tuning for Oracle 8 included.

Oracle Performance Tuning, 2nd Edition Review, September 19 2000

Rating:

Submitted by SUNIL B NETTYAM [Respond | View]

The best On Tuning, But should be updated to include oracle8i Features.

Sunil Nettyam

Oracle Performance Tuning, 2nd Edition Review, August 06 2000

Rating:

Submitted by John [Respond | View]

Pretty good book, but published in November 1996?
4 years old? I'm sure that even more depth can be gained with a new edition.

Oracle Performance Tuning, 2nd Edition Review, October 13 1999
Submitted by Sathish Anoor Varadarajan [Respond | View]

This is one of the best book I have come accross for Oracle Tuning. I feel it a MUST have book for Developers/DBA's. More emphasis should be given for Oracle8 in future issues.

Media reviews

"There's no substitute for in-depth know-how when it comes to tuning an Oracle database, and that's what you get in Oracle Performance Tuning. This book is required reading for every Oracle DBA.... It provides a great companion to using our new Oracle Enterprise Manager Performance Pack tuning products. The extensive knowledge and experience contained in these pages, combined with a good set of tuning tools, provides the Oracle DBA with a potent arsenal for Oracle performance tuning!" -- Ken Morse, Senior Product Manager, System Management Products, Oracle New England Development Center "Database performance tuning is our company's bread and butter, so I buy all the Oracle references I see. Mark Gurry's and Peter Corrigan's book is without doubt the best, offering many more practical tips and scripts based on their experience. I recommend it unreservedly to anyone with a need to improve an Oracle database's performance." -- John Symington, Technical Director, Common Sense Computing Ltd

"If you are looking for a book on performance tuning look no further." --Andrew Morris, Computing April 30, 1998

(The following are for the first edition):

"Essential reading for managers - this book establishes that system tuning commences in the development cycle of a project." --Lurline Archay, President Australia & New Zealand Oracle User Group; Vice President, International Oracle User Group

"Time = money! ORACLE Performance Tuning finally gives ORACLE readers a comprehensive guide to maximizing their RDBMS and associated hardware investment. A well-tuned database is key to every company's competitive edge. This guide encapsulates the experience and "bag-of- tricks" of dozens of ORACLE experts and insiders. It's especially valuable for programmers and DBAs, but it's also applicable to project leaders, analysts, designers, and system administrators. Patrol Software believes the book will benefit every ORACLE installation and is adopting it as an important source of expertise for Patrol's automated management and tuning of RDBMS systems." --Martin Picard, President, Patrol Software; former Director of Networking Products at ORACLE Corporation

"This book is an example of what can be achieved when professional practitioners take the time to share their experience and skill through the medium of print.... There has been a real need for this type and style of book. It is a must for every information technology professional who is working in a modern database environment, or the advanced student who has aspirations to work in such an environment." --Bob Fees, Managing Partner, R.H. Fees and Associates; executive consultant to private and public sectors in many countries including U.S., Australia, Saudi Arabia, and Thailand

(This is for the first edition)

"Performance tuning can be used not only to improve response times, but also to reduce capital (by eliminating the need for upgrades) or operating (by allowing "downsizing") costs. The more complex the system, however, the more complicated the tuning decisions. Client/server models can reduce CPU demand, but possibly add a new bottleneck in the network, itself. ORACLE is a powerful, functional, and flexible, but therefore very complex, database management system. "Corrigan and Gurry have produced a masterful, practical, and, above all, readable manual for performance tuning on ORACLE systems. There are conceptual and detailed explanations as well as tips and guides for managers and planners, designers and analysts, programmers, database administrators, and system administrators. As ad hoc reporting and queries rise, with the advent of easier-to-use tools, even the ORACLE user might benefit from some insight into what is going on behind the scenes. (OK, the *advanced* user.)" --copyright Robert M. Slade, 1995, author of Robert Slade's Guide to Computer Viruses

Hide extended reviews