Oracle Performance Tuning, 2nd Edition
Publisher: O'Reilly Media
Final Release Date: November 1996
Pages: 966

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.

Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
O'Reilly MediaOracle Performance Tuning, 2nd Edition
 
4.4

(based on 7 reviews)

Ratings Distribution

  • 5 Stars

     

    (5)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (0)

Reviewed by 7 customers

Sort by

Displaying reviews 1-7

Back to top

(1 of 1 customers found this review helpful)

 
5.0

Still the best Oracle Tuning book

By KOX

from Milano, Italy

About Me Developer

Pros

  • Accurate
  • Concise
  • Helpful examples

Cons

    Best Uses

    • Intermediate
    • Novice
    • Student

    Comments about O'Reilly Media Oracle Performance Tuning, 2nd Edition:

    I have studied many Oracle tuning books, also much newer, but this is still the best one on the market.It says how things really work, and when and why they do NOT work!No other book do that - and so appropriately.I am used to recommend an accurate study of it to all the colleagues I meet.When can we have an update of it?

    (1 of 1 customers found this review helpful)

     
    5.0

    Oracle Performance Tuning, 2nd Edition Review

    By Alan Wilson

    from Undisclosed

    Comments about O'Reilly Media Oracle Performance Tuning, 2nd Edition:

    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.

     
    4.0

    Oracle Performance Tuning, 2nd Edition Review

    By K Vainstein

    from Undisclosed

    Comments about O'Reilly Media Oracle Performance Tuning, 2nd Edition:

    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

     
    5.0

    Oracle Performance Tuning, 2nd Edition Review

    By Marcus Vinicius Ferreira

    from Undisclosed

    Comments about O'Reilly Media Oracle Performance Tuning, 2nd Edition:

    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

     
    5.0

    Oracle Performance Tuning, 2nd Edition Review

    By Wayne Vieira

    from Undisclosed

    Comments about O'Reilly Media Oracle Performance Tuning, 2nd Edition:

    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.

     
    5.0

    Oracle Performance Tuning, 2nd Edition Review

    By SUNIL B NETTYAM

    from Undisclosed

    Comments about O'Reilly Media Oracle Performance Tuning, 2nd Edition:

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

    Sunil Nettyam

     
    2.0

    Oracle Performance Tuning, 2nd Edition Review

    By John

    from Undisclosed

    Comments about O'Reilly Media Oracle Performance Tuning, 2nd Edition:

    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.

    Displaying reviews 1-7

    Back to top

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Ebook: $63.99
    Formats:  PDF
    Print & Ebook: $87.99
    Print: $79.99