Oracle Performance Tuning Tips and Techniques

by Richard J. Niemiec

is must-have revision of the best-selling Oracle Performance Tuning Tips & Techniques, is an invaluable collection of authoritative, tried-and-true tips and techniques for administrators, programmers,... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0078824346
• ISBN13: 9780078824340
• Release Date: April 1999
• Publisher: McGraw-Hill Companies
• Length: 894 Pages
• Weight: 3.80 lbs.
• Dimensions: 2.2" x 7.4" x 9.1"

Customer Reviews

Best Book on Performance Tuning

The book cover a wide range of issues related to performance tuning. It helps me better understand the magic behind oracle PT. The author is an expert in the area and used his expertise to design a PT tuning guide. I would definitely recommend this book to junior and senior dbas. I am looking forward to the upcoming 10g version that is set to be released sometimes next year.

Great read from novices to experts

The authors have really put in alot of effort in making sure that the Oracle database can be understood in every aspect, and this really makes tuning easier :) Surely, this is one of the best books around. cheers!

Review by DB2 Expert

I picked up this book to review the world of Oracle tuning and I found it contained lots of useful information. Good examples of tuning Oracle on Solaris. Many similarities of tuning points between Oracle and DB2. I particularly liked Chapter 9 on optimization queries and workloads.

Clearly the best performance tuning book EVER!

This book is a work of art! It's clear that considerable time and energy went into the research demonstrated in this book. It's amazing how many tips Rich shows off too. If you need a fast application, this book is an absolute MUST HAVE for your library. Take the time to read and understand every word written - it is SO well thought out. Rich is a genuine, caring and devoted person to the betterment of IT and fellow mankind! Great work and thank you for this work of art! This is clearly the best performance tuning book that I've ever seen!

Best Practices for Tuning...Nuts to Bolts

This book is concise, practical and thorough! It starts with a high level view of new 9i features and then drills down to the meat and potatoes of not just 9i tuning, but tuning skills that can be applied to any Oracle database. It speaks to the beginner developer and DBA as well as the seasoned veteran tuner with equal added value for each. I really enjoyed the focus of the Disk I/O and Fragementation chapter. It drills in the fact that no matter how hi-tech or low-tech your disk technology is you must adhere to the common sense basics and take ownership of your database data files, I/O, partitioning and fragmentation down to the disk level and not leave it in the hands of your Hardware Admin. I also like the way he incorporates GUI (OEM) and line command options for those who are old school DBA's. He hits the new init.ora parameters, TKPROF, and stored outlines. As always, he covers documented and undocumented init.ora parameters, and an appendix of the GV$, V$, and X$ tables. The only thing I would have wished to be added was the hard to find proper use of the 'alter session set events' functionality to trace the optimizer decision process without the use of TKPROF. If you only have room for one Oracle tuning book on your shelf, make it this one, its still the "Gold Bible for Oracle Tuning".